SQL Query??? This is Access 97 and I'm just trying to understand importing / linking information.
It is actually a different problem (i'm realizing). When I try import or link the data- it doesn't work because the SKU or barcode number of the product is the P Key- it won't let you overwrite P keys.
I guess I need a query that matches the SKU in the text file to the SKU in the database and THEN update some fields in that row...
If you can help; great. Otherwise, I have bit of learning to do via books.