Export File to another Database

[maintt]

Hi All

I have two Database's, i want to export a query from one database to another and overwrite the second database which has the same file name, when i have used the export function to export from DB1 to DB2 it ask's me do i want to overwrite the existing file, i say yes and it appears that it has worked, when i open DB2 nothing has changed, does any body know how to do this, DB1 has 350 records and DB2 has only three,

any help would be greatly appreciated



Maintt

[RuralGuy]

Have you tried looking at DoCmd.CopyObject?

[maintt]

Can you explain what I do please

Maintt

[RuralGuy]

Have you looked up CopyObject in VBA help yet? Not Access help but VBA help. Press F11 and then F1 for help.

[maintt]

Thanks RuralGuy

I wiil get on it now

Thanks for the help

Maintt

[RuralGuy]

Post back on this thread if it is still stubborn after reading up in Help.