make table query/sql

  • Thread starter Thread starter david white
  • Start date Start date
D

david white

Dim table1 as string
Dim db1 As Database
Set db1 = CurrentDb
table1 = "newtable"
select1="select field1 into table1 from oldtable"
db1.execute "select1"

works find except that it puts it into a table called
table1.
I want it to go into a table called "newtable"

Help is appreciated
 
select1="select field1 into " & table1 & " from oldtable"

Ron W
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding New Record to a linked table from Query 1
FindFirst error 3
Create new table sorted 2
Moving data from one database to other 1
Copying Specific Records From A Field According to another Field By Code 2
docmd.runsql 3
Duplicate record in Form and Subform 0
How to return a result of a SQL query within an Event Procedure(&what am I doing wrong here)? 21

Back
Top