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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Easiest way to update data in report monthly 11
Protecting powerpoint query 3
Merge fields on a query table 1
several questions RE tables 5
JPEG Images & Original Images In OneDrive Folders 3
How to export table from outlook into ms access table? 0
Text string sort limit 2
Countif for more than one criteria 6

Back
Top