Transfer data in tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


GaryLocke said:
I am trying to restore a backup of data in tables from another database. I
Click to expand...
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unlink command 4
Can DoCmd.TransferDatabase be used to move table to BE 6
Set table conditions to run Docmd 5
Link from SQL server 1
code to unlink a table? 2
Linking Files and Select Unique Record Identifier 2
Setting Primary Key on a Linked SQL Table 4
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top