I have an Excel spreadsheet with invoice numbers and am trying to import into Access database to match invoice numbers located in a table in Access. After importing my data into a table in Access I want to match those numbers to an existing table and bring back additional information located in the Access Tables. For instance I have a query which gives me invoice numbers and the total amount billed to the invoice number. I want to identify also if the invoice numbers are missing from my Access table. I realize I'm not giving a lot of information here. I hope someone will understand and give me some general guidance.
Thanks.
Bookmarks