external data & excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everybody.
I have database in excel and in linked with access table via getexternal
data|linlk. I works well. My problem is when i copy the two files into
another system it is giving some error. saying that link fine is missed.
Thanks to all for the suggestions in advance.
Regards
Sridhar
 
In the client database try clicking Tools/Database Utilities/Linked Table
Manager. Then click Select All to select all tables and put a tick in
"Always prompt for new location". Then click OK and navigate to the
database containing your tables. It may refresh all in one go or ask for
them individually.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
copy data from external file 2
link table from excel - data type problem 5
append query (data comming from excel Table link) 1
copy from external file 2
Q: Working with Embedded Excel Worksheets 2
Access Form Refresh 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top