Select INTO table "dynamic"

[Alfredomulet]

Hello everyone, is it possible with SQL (select into) to generate a table with dynamic names?

Example: Select COL01, COL02, COL03 INTO TABLE_"DATE" FROM TABLE01

where Table_"date" will be a table like TABLE_07112005, tomorrow it will be like TABLE_07122005, etc..

Cheers,
Alfredo

 

[lupins46]

dim sqlstr
sqlstr = "Select COL01, COL02, COL03 INTO TABLE_" & format(DATE(),'mmddyyyy') & " FROM TABLE01"
currentdb.execute strsql, dbfailonerror

 

[Alfredomulet]

Thanks for your fast response lupins46!! I thought about something like that, but I was trying not to use vb, is it there any other way with just SQL?
cheers,
Alfredo

 

[lupins46]

No.

You cannot use expressions for table names in the Access query processor.

 

[Alfredomulet]

OK, cheers again lupins.