Combine multiple tables (1 Viewer)

mipszzz

New member
Local time
Today, 05:57
Joined
Nov 7, 2013
Messages
1
I have very little understanding of Access but I think what I am trying to accomplish is fairly simple.

Using a scripted process, I gather data about servers and the data is dumped into Excel for each location. The format of the Excel spreadsheet is constant. Each location has a new spreadsheet but the headers remain the same.

I would like to build an Access database that "links" into these spreadsheets. This way, as a particular Excel spreadsheet is replaced with an updated version, the Access database does not need to be changed. Simply refreshed.

I have figured out how to "link" the Excel spreadsheets, now I need to combine the data from the various Excel spreadsheets into a single Table

Remember that the headers for all the spreadsheets will always remain the same, only the data will change.

Any insight would be greatly appreciated.
 

Mihail

Registered User.
Local time
Today, 14:57
Joined
Jan 22, 2011
Messages
2,373
Welcome to the AWF forum !

I think that the CREATE TABLE QUERY and the APPEND QUERY are the tools you need here.

I have figured out how to "link" the Excel spreadsheets
How you do that ?
 

Users who are viewing this thread

Top Bottom