[RESOLVED] INSERT INTO all records in a table

[mel_flynn]

Hi all,

I want insert a number and a date into all the records in a particular table. I.E. There could be 100 records in a table and I want to insert the same week# and date into all the records. However, when I try to use the INSERT INTO function of SQL it is simply adding 1 new record to the table and adding the week# and date to this record.

How do I add the week' and date to all records in the table?

Thanks,

[bushmobile]

you use the UPDATE statement to update existing records:

UPDATE table_name
SET dDate = #06/15/2006#, numWeek = 25

[mel_flynn]

Thanks a million