source for the linked table

G

Guest

I inherited an Access 97 database from one of my co-worker who is no longer
with the company. The issue is there is a linked table to an EXCEL
spreadsheet in this database and I can't figure out where the EXCEL
spreadsheet is located. In other words, I would like to know the source for
te lined table. Can somebody help me on this?

Kanan
 
B

Brendan Reynolds

Open the table in design view and select Properties from the View menu.

Alternatively, in the VBA Immediate window type ...

? CurrentDb.TableDefs("YourTableNameHere").Connect
 

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

Linked Excel spreadsheet to be used as table 3
Data Type Issue in Linked Excel Table 7
Uploading excel data to a table using linked data from two other t 4
Replacing information in a field with a linked table 10
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Linked Table with Open Source File 3
linked tables 3
Update Query from Access 2003 Linked Table 1

Top