copy table from one access database to another access database

[fabdulla]

I have a tabel A in access database A and i would like to copy tabel A into access database B. But when ever tabel A updates I want tabel B to update as well. If anyone know who to do this please help.

[Rabbit]

Just link the tables instead. File > Get External Data > Link Tables.

[fabdulla]

you see in tabel A there is column of data type text, but i would like to change it to Date/Time data type because the column contains dates. and since i cannot change it in the source, I made another database B and Tabel B and in Tabel B the column named Date I changed it's datatype from Text to Date/Time. Also because the source (archive.mdb) gets replaced everytime the data type change will take effect until the entire file gets replaced it is going to go back to it orginial formate. Is there a way to just copy from Tabel A in database A to Tabel B in database B and keep the updates from A to B.

[Nathan H]

you see in tabel A there is column of data type text, but i would like to change it to Date/Time data type because the column contains dates. and since i cannot change it in the source, I made another database B and Tabel B and in Tabel B the column named Date I changed it's datatype from Text to Date/Time. Also because the source (archive.mdb) gets replaced everytime the data type change will take effect until the entire file gets replaced it is going to go back to it orginial formate. Is there a way to just copy from Tabel A in database A to Tabel B in database B and keep the updates from A to B.

You can make Table B using a Make A Table query using the Linked Table A as the source and then use CDate([date]) in the query on the date field to change it from text to date.