concatentating tables

G

ginger

I have 43 offices with 43 files I would to put together. How can I import and
concatenate them in the most effecient method? Presently I am trying to do it
using a maco to import. Then I am stuck between trying to write a query to
append them all together or what?
 
K

KARL DEWEY

What you are wanting to do is not "concatentating tables" but appending them.

Click on File - Get External Data - Import.
Select the type of file you want to import. Import.
Do it again but this time have it append to an existing table instead of
making a new table.
 
Top