Error in OPENROWSET Export excel

Question

0.00/5 (No votes)

See more:

SQL

insert into OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\Tracking.xls;;HDR=YES', 'SELECT * FROM [Sheet1$]') select * from TDR

am using this query to export .

But getting error message

SQL

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "The Microsoft Jet database engine could not find the object 'Sheet1$'.  Make sure the object exists and that you spell its name and the path name correctly.".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

Posted 12-Mar-13 21:55pm

kimberly wind

Add a Solution

Comments

RedDk 13-Mar-13 13:48pm

Is it possible that OLE DB Providers that run in single-threaded apartment mode cannot be used for distributed queries?

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)

gvprabu · Answer 1 · 2013-03-12T22:37:00

Solution 1

Hi,

May be your Source Excel Sheet already Opened or Path of the Excel Sheet is not correct...

Check the links...

SQL Server 2008 - Import-Export Wizard [^]
Export to Excel[^]
SQL SERVER – 2005 – Export Data From SQL Server 2005 to Microsoft Excel Datasheet[^]

Regards,
GVPrabu

Posted 12-Mar-13 22:37pm

gvprabu

Comments

kimberly wind 13-Mar-13 5:13am

Nope everything is correct . I don't want to export via wizard . thro query only wanna do

gvprabu 13-Mar-13 5:17am

Yes,
In that link Sample Query also there.... check the links

Maciej Los 14-Mar-13 16:46pm

+5 for links!