Copy Crosstab query result to table

[chris186h]

Hello all.
Im looking for a sql code or macro to copy the data from one query into another table.
The source data for the crosstab query(DATA_Crosstab) will change daily and i would like to keep a record within access in the ByArea table.

The below code copies over fine but asks to delete the table first. I would like to keep all the previous data and just add the record below.

select * into ByArea
from DATA_Crosstab

Many Thanks in advanced, im very new to access

 

[Joe4]

The code you have posted is for a "Create Table" query.
If you want to add new records to an existing table, you instead want to use an "Append Query".
See: https://msdn.microsoft.com/en-us/library/bb208861(v=office.12).aspx