excel and table - SQL Server Forums

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)

excel and table

Author

Topic

sardinka
Posting Yak Master

142 Posts

Posted - 2006-10-12 : 09:46:38

is it some how I can load excel into table using storedprocedure (not a dts)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-12 : 09:49:54

Yes. Look at http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Peter Larsson
Helsingborg, Sweden

sardinka
Posting Yak Master

142 Posts

Posted - 2006-10-12 : 13:41:16

I got this error when I run the statement.
I have Excel XP Professional
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: The Microsoft Jet database engine could not find the object 'Sheet2$'. 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: ].

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-12 : 21:19:52

As the error says, make sure that you spelled the sheet name correctly

Madhivanan

Failing to plan is Planning to fail

sardinka
Posting Yak Master

142 Posts

Posted - 2006-10-13 : 11:31:05

It spelled correctly

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-13 : 11:33:16

even with the [ and ] ?

Peter Larsson
Helsingborg, Sweden