Access VBA Converting a linked table to a normal table

Hi

Is there a way of converting a linked table to a normal table in Access VBA? So effectively copying the linked table into a normal
table.

Thanks
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
SELECT LinkedTableName.* INTO NewTable
FROM LinkedTableName

 
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
 
rockiroadsCommented:
Howdo Murray, have u not already done that?

U got code that converts linked table already, if u remember, it created I_ <<tablename>>

And what about the linked text files?

Regarding the newly created tables, if u want to remove the linked table and rename it to that linked table, u wont then be able to get your daily updates



0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi rockiroads. You are right. You did already help mw with that, but it has been a long day and it slipped my mind. Trying to get an urgent job through, which is separate from the one that I asked you about.

Thanks for the help
0
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.