Replace Data In A Table

  • Thread starter Thread starter pjscott
  • Start date Start date
P

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
 
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.
 
Back
Top