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 excel into SQL? AceOleDb…that’s how. Continue reading “Direct query to excel (AceOleDb.dll)”