Loading Access Table from other datasource

[dinger]

Hello,
I have some tables in an advantage database (similar to SQL Server). I would like to import these tables into an Access database and am looking for the most efficient method of acheiving this.
I am currently using dao to accomplish this - using currentdb.execute "select tablename into newtable from " & ODBC;dsn = ...."

Can anyone make any suggestions?

Thanks

 

[llkhoutx]

Can you use a make table query?