Combine Multiple properties lists

[elfranzen]

OK, not sure how to search for this so I am just going to ask. I have two properties that send me excel sheets with the name of the employee, employee number, department, and title. What I would like to do is make this into one list. So just one table that would list these fields and maybe get a new field that marks what property that person works at.
Example
Jon Smith, 12345, admin, office ( this is from one list)
Jane Smith 54321, admin , office (this from the other list)

What I want it to look like (query)

Name, Emp #, title,department,property
Jon Smith, 12345,admin,office, prop1
Jane Smith,54321,admin,office, prop2

How would i go about doing this?

 

[jdraw]

OK, not sure how to search for this so I am just going to ask. I have two properties that send me excel sheets with the name of the employee, employee number, department, and title. What I would like to do is make this into one list. So just one table that would list these fields and maybe get a new field that marks what property that person works at.
Example
Jon Smith, 12345, admin, office ( this is from one list)
Jane Smith 54321, admin , office (this from the other list)

What I want it to look like (query)

Name, Emp #, title,department,property
Jon Smith, 12345,admin,office, prop1
Jane Smith,54321,admin,office, prop2

How would i go about doing this?

In general terms:

You could have a database say MyDatabase.
You could create a Table (MyCommonTable) with fields Name,EmpNo,Dept,Title,and PropertyId.
The excel files (say Info1 and Info2) could be placed in a known location on your computer. In the database, you can link to Info1.xls and to Info2.xls
Create an Append Query to insert data from the xls files into your common table, making sure you put in the correct property identifier when you run the query.

For the query you would like:

SELECT Name, EmpNo, Dept, Title, PropertyId from MyCommonTable.

Suggest you don't use Field names with embedded spaces. Also, beware of field names that are Reserved Words in Access.

Here are some references that could be useful.
http://r937.com/relational.html
http://www.allenbrowne.com/casu-22.html
http://www.btabdevelopment.com/main/AccessSamples/tabid/54/Default.aspx

 

[elfranzen]

This worked thanks. I just made a macro to run the appends at startup to this will happen in the background. again thanks