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
 
Back
Top