Linked issue on a DB using Excel file not on C: drive

[ldiaz]

A table on my database is linked to an excel file, it was working great
while it was linked to my C:\Dispatch\myexcelfile.xls , but now I moved the
DB to shared drive named: B:\Shipment System (\\aisafbe\SS$) and now it's
showing an error:
================================================
The Microsoft JET database engine could not find the object "myexcelfile".
Make sure the object exist and that spell its name and the path name
correctly.
=================================================


how can I fix this issue,

the rest of the DB work perfectly

Thanks
LD

 

[Jerry Whittle]

Did you use the Linked Table manager to refresh the link to \\aisafbe\SS$ ?

 

[ldiaz]

Yes I did and at the time to get the new Patch Name and the file is when it
shows the message.

do you knwo how it can be fixed?

 

[ldiaz]

I have dfixed the issue,

by mistake I change sheet name , even when file name is the same, that was
the issue,

I renamed the sheet name and now it's working OK..

Thanks for your quicky response, I personally apprectiate so much.

 

[aaron.kempf]

use a real ETL tool. Just _IMPORT_ the data. That way; when you need
a new copy of it-- you just import a new copy of it.
And then you don't need to worry about changing the path.

The so called 'Linked Table Manager' isn't helpful.. IMHO

-Aaron