Transfer data in tables

[Guest]

I am trying to restore a backup of data in tables from another database. I am using the DoCmd.TransferDatabase (acTable) command but this will not copy the table over the top of the original table as my original table has relationships which would be destroyed

Is there a better way of doing this or a way of copying over the data?

Please help

 

[Alex Dybenko]

i think better to use delete and then append queries

and if you need to restore all tables - just replace mbd with tables

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

I am trying to restore a backup of data in tables from another database. I

am using the DoCmd.TransferDatabase (acTable) command but this will not copy
the table over the top of the original table as my original table has
relationships which would be destroyed.