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.
| Author |
Topic |
|
lemondash
Posting Yak Master
159 Posts |
 Posted - 2009-06-17 : 05:18:48
|
| Every now and then i have to update data in a excel sheet.Normally i have to copy the excel file to the database server and create a linked server and then after i have finished copy the excel sheet back to my pc.Has anybody got it working from a shared folder locally on there pc.I'm trying it now with no joy its creates the linked server with no errors, which makes me think it can see the file. but when querying the file it errors.OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LOCAL" 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.".Msg 7306, Level 16, State 2, Line 1Cannot open the table "Sheet1$" from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LOCAL". The specified table or view does not exist or contains errors.any help would be great. |
|
|
lemondash
Posting Yak Master
159 Posts |
Posted - 2009-06-17 : 05:21:51
|
| I just restarted my SQL Management studio and now it works. |
 |
|
|
|
|
|
Linked Server