Could you use VLOOKUP formulas in the 3rd sheet to look up data in each of
the seperate sheets rather than importing and exporting?

"Connie" wrote:

how do i combine 2 different excel spreadsheet in access & import it back to
excel as 1 spreadsheet.

This is what i am trying to accomplish
turn 2 spreadsheets into 1 using an item number as the common denominator
the new spreadsheet has to have all the updates from both spreadsheets.

Thanks, I welcome any and all suggestions.