Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

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
0
Murray Brown
Asked:
Murray Brown
  • 2
1 Solution
 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now