Merging multible linked tabels to one

[matjcb]

Sorry newbe here.
In short we are pulling data from multiple AutoCAD files into multiple excel
files. Then we are linking those Excel file as multiple tables into one
Access database, this data base is linked to multiple tables from our ERP
system.
I would like to some how get the multiple excel linked tables from AutoCAD
to one common list table, like merged together somehow so I could easily do
queries off one table with our ERP system.

Is this possible?

 

[Allen Browne]

You can use an Append query to append the data from an attached table to a
local table. (Append on the Query menu, in query design view.)

You will need to execute an append query for each of the attached Excel
files. Naturally there may be issues to sort out here, e.g. to ensure the
data types are correct, the required columns have data, lookup values do
exist, and there are no duplicates in uniquely indexed fields.