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!