Importing from linked tables

[bpleshek]

Hey all,

I have some tables linked by Teradata ODBC. I wish to import some tables which are structural and data copies of these tables through VBA. So far whatever I have tried has only ended up being also a linked table. I wish the result to be a local table. I'm trying to build an offline "copy" of a database for use in the field. Any help would be appreciated.


Thanks,

Brian Pleshek

(PS Sorry for the xpost, but I wasn't sure I'd get a response in the table section after I posted it).

 

[Uncle Gizmo]

This works against an Access backend, I don't have the facility to check it against an ODBC data source but I can foresee no reason why it shouldn't work.

Click on the linked table that you want a local copy of. Click on the query wizard, Select design view, now drag all of your fields into the query grid.

Select "make table query" and give it a suitable name. Hopefully this should generate you a new local table!