"Exporting" ODBC table to another database

[CedarTree]

Hi - to try to not store data directly in my main Front-End, I use a temporary database to store local tables, etc. I want to make a copy of an ODBC table and copy it as a local table into my temporary Access DB. When I DoCmd.TransferDatabase acExport, the ODBC table copies into the temp database, but it stays a linked ODBC table. I can (I think) convert a table to a local table, but how do I do that in my temporary database from the VBA in my front end? Thanks!

 

[Ranman256]

You can just run an append query,
Or a make table query.

Same as a copy.

 

[isladogs]

From your temp database, import the table you want.
If it's a linked table in the source database, it will still be a linked table.
If so, right click on the table and select convert to local table
OR right click, select copy then click paste as local table (structure and data)

EDIT Forgot to say, I'm not sure you can convert a linked table to a local table in another database for security reasons

 

[CedarTree]

I'm trying to do it in VBA. Make table was the way to go. Thanks.