Import from another MDB to Linked table

  • Thread starter Thread starter Andibevan
  • Start date Start date
A

Andibevan

I need to transfer the entire contents of a table from a seperate MDB file
into my current MDB file. The problem is I need to transfer the contents of
the table into the linked table.

I have tried an SQL statement "SELECT * INTO destinationTable FROM
sourceTable" but this overwrites the linked table every time. I have been
looking at transfertext but it doesn't seem to be suitable - any ideas?
 
Hi Andi - To Link go to the File Menu, then to Get External Data, Link Files.
You then find your other MDB and choose the Table you want. This puts the
Table name into your list of tables but with a black arrow to the left of it.
You can now use this table like any other, just remember it updates the table
in the other MDB also. This is why you should then do a Make Table (for a new
Table) or Append the data to an existing Table. Then delete the linked table
from the list (does not delete the table in the other MDB). Hope this helps,
yell if you need some more info. Yours - Dika
 
Thanks Kernow - much appreciated

Kernow Girl said:
Hi Andi - To Link go to the File Menu, then to Get External Data, Link Files.
You then find your other MDB and choose the Table you want. This puts the
Table name into your list of tables but with a black arrow to the left of it.
You can now use this table like any other, just remember it updates the table
in the other MDB also. This is why you should then do a Make Table (for a new
Table) or Append the data to an existing Table. Then delete the linked table
from the list (does not delete the table in the other MDB). Hope this helps,
yell if you need some more info. Yours - Dika
Click to expand...
 
Back
Top