Automate conversion of ALL linked tables to Local within MDB file

[Poduska]

I need a bit of code to automate the conversion of ALL linked tables (there are 65) into local tables.

The idea is to take any database and use it as a testing and development file without worrying of corrupting the production data as everything is local.

Ok, I know someone has a quick bit of code as I did have one which worked great but disappeared during a "disk cleanup" after I used it once and though "cool".

I remember it looped through the table collection but can't seem to get google to find what I once had.

Any ideas on paths I may use to achieve these results would be helpful.

thanks

 

[MajP]

Why do you need code to do this? Can't you just select all the tables and import? I do not see what you would be saving by writing code to do this. Are these not access tables?

 

[Poduska]

It would be just a convenience as the linked table sources are from 5 databases and 2 different Excel files all located on various network drives. Just quicker and the one procedure I had found a while back just worked so good. I was hoping it was here where I found the code.

Thanks.