Import Excel workhseet into SQL Server 2008

Question

4.00/5 (1 vote)

See more:

I am using this syntax to read my excel file into SQL Server Management Studio 2008

SELECT * 
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
                'Excel 8.0;Database=C:\proj\test.xls',
                'SELECT * FROM [Sheet1$]')

But it throws error

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.

I am suspecting JET OLEDB is not installed on my Windows XP. Although I do see the MsJet40.dll dll in System32 folder

When I look in Control Panel -> Adminstrators tools -> ODBC Admin, I do not see OLE DB in the drivers list. Could this a problem. If yes can someone guide me how to install it.

I went to http://support.microsoft.com/kb/239114[^] but after installation, it says I already have the latest updates. Can someone help.

Posted 20-Apr-12 2:54am

sharp_k

Updated 20-Apr-12 2:57am

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kimberly wind · Accepted Answer · 2012-04-20T04:10:00

Solution 2

try this link
http://dotnetslackers.com/articles/sql/Importing-MS-Excel-data-to-SQL-Server-2008.aspx[^]

Posted 20-Apr-12 4:10am

kimberly wind

Comments

sharp_k 20-Apr-12 10:54am

Awesome. Great help. I did follow this before, apparently the default name it chooses for destination table is wrong. This tutorial walks you step by step. Thanks

kimberly wind 20-Apr-12 11:02am

Okie enjoy :)