Two Excel Spreadsheets, One Access Table

[Mattine]

How do I combine two excel spreadsheets into one Access table?

In one Excel spreadsheet, I have customer name, number, and address.

In the other, the same information, but I need the serial number, make, and model to match up to the customer information on the first Excel Sheet.

 

[AvGuy]

Import both Excel sheets into Access as separate tables. Then combine normally with an append query.
AvGuy

 

[BNPMike]

"In the other, the same information, but I need the serial number, make, and model to match up to the customer information on the first Excel Sheet."

Not 100% clear what you are saying. Are the tables identical? Are they identical but you are going to have to add some extra data to the second one? Is the second one actually already containing a number of lines per customer, each line with a key serial number + make (model would be determined by the key)?

Maybe you could list the significant fieldnames in each spreadsheet.