Appending an Existing Excel Sheet

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Appending an Existing Excel Sheet

Author

Topic

vishu_av
Yak Posting Veteran

69 Posts

Posted - 2007-10-31 : 00:17:17

Hi All,

I would like to append an existing Excel sheet which initially has some of the rows ( Doesnt pertain to any table or columns).
I tried doing 'insert into openrowset(......)' where i tried to insert data from a table.
I get this error

[OLE/DB provider 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.]
OLE DB error trace [OLE/DB Provider 'MICROSOFT.JET.OLEDB.4.0' IColumnsInfo::GetColumnsInfo returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MICROSOFT.JET.OLEDB.4.0' reported an error.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-10-31 : 02:30:09

As it says make sure the file name and sheet names are correct
Also read this
http://sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-10-31 : 02:32:20

Also make sure the file is in Server's directory and not in the client system. Otherwise you need to use \\client_name\path.........\file_name.xls

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources