Solved

Access VBA Converting a linked table to a normal table

Posted on 2006-11-07
4
451 Views
Last Modified: 2008-02-01
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
Comment
Question by:murbro
  • 2
4 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 17890086
SELECT LinkedTableName.* INTO NewTable
FROM LinkedTableName

 
0
 

Author Comment

by:murbro
ID: 17890192
Thanks very much
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17890207
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
 

Author Comment

by:murbro
ID: 17890244
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question