import excel link file

[iraidotel@yahoo.com]

Dear All,



Please enlighten her,

I want to create a database where I import data from Excel, which excel is a link to a file folder for the file scan

In the excel file link does not matter, after I import into Access 2003 link does not work anymore.

Does anyone know this problem



Thank you



Regards, Ira

 

[Ranman256]

If you have linked the Excel file as a table, the link is permanent until you remove it.
but the link is broken IF:

• you delete the file
• if the filename is different
• if the filename is the same but the sheet connected is different.