Import table from one database to another

[ezfriend]

How can I PROGRAMATICALLY import a table from one Access database to another?

I see a lot of example for import text file, csv, excel, etc, but could not locate one with Access to Access.

I know the "manually done" way, of course, but need to automate the process.

Thanks a lot in advance.

EZfriend

 

[MikeC1408]

Have a look at DoCmd.TransferDatabase

set to acImport and apply the path of the target db and set type to acTable

Hope this helps