SQLError - 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)

SQLError

Author

Topic

vmurali
Yak Posting Veteran

88 Posts

Posted - 2007-06-13 : 07:17:10

Hi When I am trying to import data from excel to SQL using openrowset I am getting an error

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)"

Can anyone tell what is the error and how to solve it.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2007-06-13 : 07:40:05

looks like you are trying to open an excel file that does not exist.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-13 : 08:58:39

Also, when importing data make sure that the file is not opened or accessed by other applications
For more information, refer
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-13 : 11:06:04

Does sql service account have permission on that excel file?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources