I've got about 70 tables linked to our main db. I want to copy those linked tables into regular nonlinked tables (including structure and data). Simple make table queries work just fine, but the number of tables involved makes this a tedious prospect. I am using Access 2003.
The naming convention is dbo_TableName for the linked tables and 0_TableName for the nonlinked table.
For example, the code for a single table is :
SELECT dbo_tblCoursesArchive.* INTO 0_tblCoursesArchive FROM dbo_tblCoursesArchive;
I would like some code that would loop through each linked table and make a nonlinked table.