MS Access Insert into SQL - add timestamp column

[Hudas]

Hi ,

I have the below SQL statement... In table2 there is another field called timestamp1... Is it possible to have the timestamp1 included in the below statement so that I will have a record of time the moment the records were inserted in table2? There is no timestamp1 field in table1.

strSQL = "Insert Into Table2(Business_Unit, Account)  Select Business_Unit, Account From Table1"

Thank you very much!
hudas

 

[TJPoorman]

Insert Into Table2(Business_Unit, Account, timestamp1) Select Business_Unit, Account, Now() From Table1