Import from another MDB to Linked table

[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?

 

[Guest]

Just link to the other mdb and use an append query.

 

[Andibevan]

What do you mean by "Link"? And how do I do this using VBA?

Tia

Andi

 

[Guest]

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

 

[Andibevan]

Thanks Kernow - much appreciated

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