Replace 4 local tables with linked tables and make them local tables using VBA code

Is there a way to delete 4 local tables with linked tables and then make the linked tables local tables using VBA code?
Who is Participating?
Gustav BrockCIOCommented:

Create a new database.
Export the tables to the new database.
Delete the tables from current database.
Link the tables from the new database, The table names will not have changed.
This question doesn't make any sense.  Please clarify.
SteveL13Author Commented:
Here is my situation. I have 4 linked tables in my database. But because of network speed issues I need to delete those linked tables and re-link to them BUT then convert them to local tables.

I hope this makes sense now.
Gustav BrockCIOCommented:
It did and still does.
re-link to them
No.  You wouldn't relink to them if you were going to import their data into local tables.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.