Replace Data In A Table

[pjscott]

I'm using sql 2000 and Access 2003.

I have a table contains all the payroll data and a table that contains
current payroll data. Each paydate I need to replace the data in the current
payroll table with the current payroll data.

In Access I could run a Make Table query that would do this.

How can I do this with sql and Access?

Thanks for the help,

Paul

 

[Rod Behr]

Continue to use Access if your SQL programming skills are at issue. Use an
Append query to add the data to the end of the existing table.