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
