Solved

Access VBA Converting a linked table to a normal table

Posted on 2006-11-07
4
450 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

810 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