VBA making table from ODBC

[dlugirapfr]

Hi,
In my access file I have connections for 7 odbc links tables.
Is there any option to make macro that can make normal table from this links ? The name of table will be the same like name of links. And when i run this macro again this macro will delete all information and make table with the same name but with fresh contents...

Thanks for replay.

 

[apr pillai]

I think you don't need any VBA Code to do this. With slight change in your approach and with Make-Table Query it can be done.

For example:

1. Your ODBC Linked table Name is Table1.
2. You would like to create the target local Access table: Table1.
   
3. If I understood you correctly then rename the linked table name to Table_1 and keep it that way for future use also.
   
4. Create a Make-Table Query from the Linked Table_1 and give target name as Table1.
   
5. Repeat this method for other linked tables also.
   
6. Organize all the Make-Table Queries in a Macro and whenever you run the macro it will create fresh tables overwriting the existing ones with new data from the linked tables.