Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • Excel

Tag: Excel

Direct query to excel (AceOleDb.dll)

January 30, 2016 Steve Schneider

So, often you need to get excel data into SQL ‘in a hurry’ for analysis.  After you’ve done a base case analysis you can go about getting the data in a more ‘regular’ fashion.  What’s the fastest way to get an…

Read more

SSISAceOleDB.dll, Excel, Import, SQL, SSISLeave a Comment on Direct query to excel (AceOleDb.dll)

Importing data from Excel

July 25, 2011 Steve Schneider

Importing data from excel is very easy and you have several options to get you started…

SQL 2000, SQL 2005, SQL 2008Data Import, Excel, Import, SQLLeave a Comment on Importing data from Excel
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes