Solved How to copy records from one database to another including attachments files

[atiqahmed]

Hello everyone,

I want to copy my records form one database to another database with attachments files. where records should be copied ID to ID. CustomerFile database records copy into MyDataBase. both database files are attached please help me to solve this matter.

 

[bob fitz]

Cross-posted at: https://www.accessforums.net/showthread.php?t=83322

Please read: https://www.excelguru.ca/content.php?184

 

[arnelgp]

open frmCopyTable.

 

[atiqahmed]

Dear Arnelgp thanks alot for your wonderful VBA code it is working but there is little bit issue it is copying complete table and pasting on another database, i want to just copy records including attachments and paste into another database based on ID field. can you please modify it.

Thanks alot
awaiting your prompt reply

 

[arnelgp]

records should be copied ID to ID

this is what you want in post#1?
if id by id, then you mean exact copy?

 

[atiqahmed]

Sorry to say i couldn't make you understand. what i mean to say that just copy records from one database to another database. in your file you paste complete table where it replace the old data. ID to ID mean exact copy but old data should be remain there.

 

[arnelgp]

you mean Append records to the other database?

 

[atiqahmed]

Yes but including attachment files....

 

[arnelgp]

here try this (for appending).

 

[atiqahmed]

here try this (for appending).

Thanks alot dear it is working 100% thanks alot

 

[arnelgp]

goodluck