469,344 Members | 6,099 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,344 developers. It's quick & easy.

copy table from one access database to another access database

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.
Nov 19 '07 #1
3 3414
Rabbit
12,516 Expert Mod 8TB
Just link the tables instead. File > Get External Data > Link Tables.
Nov 19 '07 #2
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.
Nov 21 '07 #3
Nathan H
104 100+
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.
Nov 21 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Jeroen Pot | last post: by
7 posts views Thread by lgbjr | last post: by
4 posts views Thread by JIM.H. | last post: by
7 posts views Thread by ShyGuy | last post: by
4 posts views Thread by colmkav | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.