SQL - Update Query

  • Thread starter Thread starter briank
  • Start date Start date
B

briank

I would like to append several tables into one master
table. I am trying to do it by altering the SQL command
on one of the wizards but keep getting errors. Any
assistance the following logic would be appreciated.

INSERT INTO tblRegionAD
SELECT tblSouthWindsor.*
FROM tblSouthWindsor
INSERT INTO tblRegionAD
SELECT tblStafford.*
FROM tblStafford;
 
-----Original Message-----
I would like to append several tables into one master
table. I am trying to do it by altering the SQL command
on one of the wizards but keep getting errors. Any
assistance the following logic would be appreciated.

INSERT INTO tblRegionAD
SELECT tblSouthWindsor.*
FROM tblSouthWindsor
INSERT INTO tblRegionAD
SELECT tblStafford.*
FROM tblStafford;
.
create an append query for each table you are inserting
Click to expand...
then create a macro to run the queries. On the first line
of the macro use the setwarnings to no and the last line
setwarning to yes
 
Creating append queries may work but I have 31 tables to
work with. Although this is a possibility I was hoping
for a SQL string that would make this a whole lot easier.
Any thoughts?
 
Back
Top