Multiple Tables into One Table

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a database of 150 tables, withb the same field
definitions and I would like to combine them into a
single table.
I would like to use macro/module to do this rather.
I do it manually by exporting each table to Excel and
then import each one, this is very time consuming!!

Help please?
 
Set up a append query. See the Access help file. No macro needed just
run the query.
 
Back
Top