Excel Problem - 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 2005 Forums

Transact-SQL (2005)

Excel Problem

Author

Topic

chayolle
Starting Member

13 Posts

Posted - 2007-12-26 : 00:54:24

Hi everyone, I'm new to this forum and I hope you guys can help me.

A client gave me his old database to import them in a new one, but he gave it to me in .xls format. I am using the MSSQL Server Management Studio Express Edition and I want to import it from excel. I tried the following code but I have this error

Code:


Insert into lffield Select SugarYld FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\Previous Crop.xls;HDR=YES',
'SELECT YieldCurrent FROM [Previous Crop 2006$]')

Error:
Msg 7399, Level 16, State 1, Line 1
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.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-12-26 : 01:16:26

All the problems are addressed here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources