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
shieldscoAsked:
Who is Participating?
 
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.

All Courses

From novice to tech pro — start learning today.