Create SQL

[§tudz]

Hi,

I'm trying to archive my records from one table into another.

This is the SQL I am using:

CreateCommand.CommandText = _
"CREATE TABLE " & "tbl_Arch_Bids_" & Day(Now) & "/" & Month(Now) & "/" & Year(Now) & " SELECT * FROM tbl_Bids"


this creates a table named:

tbl_Bids_Arch_(Day)/(Month)/(YEAR)


but this just seems to error?

I want to copy the records from (not move) tbl_Bids to the newly created table?...

What is wrong with my statement?

Thanks

[mendhak]

How about using SELECT INTO?