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 Administration (2000)
 linked server excel for 64-bit

Author  Topic 

leff_f
Starting Member

2 Posts

Posted - 2006-02-07 : 04:46:44
hi. I have problem with Ole db Jet provider 4.0 in 64-bit MS SQL server It's not exists then i try to select provider manually for linked server but then i use sp_addlinked - everything is ok but i can't use my linked server because of:
Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'.
OLE DB error trace [Non-interface error: CoCreate of DSO for Microsoft.Jet.OLEDB.4.0 returned 0x80040154].

What should i do? find new MDAC or something else?

p.s. I try to link excel sheet.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-02-07 : 07:24:58
You might want to look at http://www.mcse.ms/archive94-2004-11-1251351.html

Go to Top of Page

TimS
Posting Yak Master

198 Posts

Posted - 2006-02-07 : 17:08:23
You might try and see if the solution for access listed here can be modified for excel

http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html

Tim S
Go to Top of Page

leff_f
Starting Member

2 Posts

Posted - 2006-02-08 : 00:33:10
RickD: thanx a lot it's really helps !!!!!!! :)
Go to Top of Page
   

- Advertisement -