Excel ODBC Driver

I want to be able to sort through an Excel/CSV file using SQL commands. Is there any way that I can do that?
pzkhanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Anthony MellorConnect With a Mentor Chartered AccountantCommented:
you can also do it with MS Query and also Powerpivot (SQL is within)

ps your version of Excel is highly relevant.
0
 
Anthony PerkinsCommented:
If SQL Server is 32 bit you can use the JET driver and specifically OPENROWSET()
0
 
dlmilleConnect With a Mentor Commented:
Yes, using VBA you can adapt the following to sort through a CSV file:

http://vbadud.blogspot.com/2008/09/opening-comma-separate-file-csv-through.html

And, you can adapt the following to sort through an Excel file:

http://support.microsoft.com/kb/257819

Here's another good link I use as a ready reference:
http://www.erlandsendata.no/english/index.php?t=envbadac

If you need further assistance, please don't hesitate to ask.

Dave
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.