?
Solved

Excel ODBC Driver

Posted on 2012-04-08
3
Medium Priority
?
642 Views
Last Modified: 2012-06-21
I want to be able to sort through an Excel/CSV file using SQL commands. Is there any way that I can do that?
0
Comment
Question by:pzkhan
3 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37822142
If SQL Server is 32 bit you can use the JET driver and specifically OPENROWSET()
0
 
LVL 42

Assisted Solution

by:dlmille
dlmille earned 1000 total points
ID: 37822159
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
 
LVL 9

Accepted Solution

by:
Anthony Mellor earned 1000 total points
ID: 37834761
you can also do it with MS Query and also Powerpivot (SQL is within)

ps your version of Excel is highly relevant.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question