Monthly Archives: January 2016

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