Imported files

[mcp201]

I wanted to find out how you know where an imported table/file in an Access
database comes from?

 

[Dirk Goldgar]

I wanted to find out how you know where an imported table/file in an Access
database comes from?

If you are talking about files or tables that have been imported into Access
tables, I don't believe there is any way. Files or tables that are linked,
not imported, have that information stored in the Connect property of the
DAO TableDef object that represents the linked table. In access 2002 (I
think) or later, hovering the mouse pointer over a linked table in the
database window displays a tooltip showing path to the linked file.

 

[Jerry Whittle]

Does the table name have anything to give you a hint? Or the data/fields in
the table?

Is the data imported by a function or macro?

 

[John W. Vinson]

I wanted to find out how you know where an imported table/file in an Access
database comes from?

Not unless that information was recorded somewhere at the time of import.
Access does not know or care.