Improve company productivity with a Business Account.Sign Up

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

convert linked access table to local table data and structure

I need to convert a linked access table to a local table... data and structure. I would like to use VBA not a make table
0
shieldsco
Asked:
shieldsco
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
this  called in vba, the sql is a make table

currentdb.execute "select tableLink.* into NewTable from tableLink"
0
 
PatHartmanCommented:
The query Rey posted is a make-table query.  He's just running it from VBA.  Is that what you were looking for?  If not, you need to use DAO or ADO or the methods of the TableDefs collection.

Why do you not want a make-table query?
0
 
PatHartmanCommented:
Apparently you did want a make-table query despite what your request said.
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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