concatentating tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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