Export to Access Database

[Ripley]

Hi, just a quick question. Is there any way of exporting say a query, or a range of quieries to another seperate access database file? ie. create a new database in code?

 

[scouser]

Import

Create your blank database then from 'File' select option to 'Get External Data' then 'Import'. Browse to your exisiting DB and select the items you wish to import.
Regards,
Phil.

 

[Ripley]

Clearly, that works equally as well as, but the question i implied was is there a way to integrate VBA code into this?

 

[Michael J Ross]

DoCmd.CopyObject would appear to do what you want
http://msdn2.microsoft.com/en-us/library/aa212269(office.11).aspx

 

[boblarson]

DoCmd.TransferDatabase will also work.