Select ... Into

[MvP14]

Hi,

can anyone tell me whether it is possible to create a new table1 in which all the results of query1 are entered by using the select ... into command? I just don't seem to manage to do it.

Thanks.

 

[Mile-O]

On the QBE grid, change the query type to a Make Table Query.

 

[MvP14]

comment

here is what is have so far:

db.Execute "SELECT Query1 INTO " _
& "[Table1] FROM Datatable; "

Query1 is a query selecting records fro m Datatable

 

[MvP14]

Query1

Query1 is a query created using db.CreateQueryDef right before I create table1

 

[Mile-O]

Ah, the SELECT part of the statement should select the fields, not a table/query object. You don't need to bother with the source table as the query (Query1) will get its information from that.

db.Execute "SELECT * INTO " _
& "[Table1] FROM Query1; "

 

[MvP14]

OK. Now it works. Thank you.