Tag Archives: Excel

Direct query to excel (AceOleDb.dll)

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 … Continue reading

Posted in SSIS | Tagged , , , , | Leave a comment

Importing data from Excel

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

Posted in SQL 2000, SQL 2005, SQL 2008 | Tagged , , , | Leave a comment