Mike_In_Ga
Registered User.
- Local time
- Today, 18:31
- Joined
- May 27, 2008
- Messages
- 32
I have an Access Db where I am pulling in (via ODBC/USQL) linked tables to an ERP system (C-ISAM). I would like to be able to convert the linked tables to regular tables. The only way I know how to do this is to run a make table query for each individual linked table. There are several hundred linked tables so this would take a long time.
Is there a way to create "regular" tables from all the linked tables in one step? If so, would it be possible to create the "regular" tables in a seperate Db?
Thx
Is there a way to create "regular" tables from all the linked tables in one step? If so, would it be possible to create the "regular" tables in a seperate Db?
Thx