N
nj2la96
I'm creating a database in Access 2007. Basically, what I'm trying to
accomplish is this...
a file gets imported from Excel into a temp table. The user views the
"new"records in the table and then decides whether to POST it to the main
table or not. The excel sheet have about 15 columns and the temp table and
main table have similar structure.
What I can't figure out is how to do an unmatched query on ALL columns and
not just one. The reason is that a record in the excel spreadsheet may be
updated (e.g the status of a serial number can be changed from "In Stock" to
"Damaged") but I want to be able to track all entries made. My final product
should be like this for example
serial1 12/1/10 Damaged (this will be imported in month2)
serial1 01/1/10 In Stock (this would be imported in month1)
serial2 03/5/10 Sold
The database should treat the 12/1/10 entry as new because the status is not
the same.
How can I do a query to compare ALL columns in the temp and main table to
produce only new or updated records??
accomplish is this...
a file gets imported from Excel into a temp table. The user views the
"new"records in the table and then decides whether to POST it to the main
table or not. The excel sheet have about 15 columns and the temp table and
main table have similar structure.
What I can't figure out is how to do an unmatched query on ALL columns and
not just one. The reason is that a record in the excel spreadsheet may be
updated (e.g the status of a serial number can be changed from "In Stock" to
"Damaged") but I want to be able to track all entries made. My final product
should be like this for example
serial1 12/1/10 Damaged (this will be imported in month2)
serial1 01/1/10 In Stock (this would be imported in month1)
serial2 03/5/10 Sold
The database should treat the 12/1/10 entry as new because the status is not
the same.
How can I do a query to compare ALL columns in the temp and main table to
produce only new or updated records??