Hi guys,
I have a invoice details table in excel format which I need to import in Access, on weekly basis. importing is not an issue and everything is working fine. But i would first like to verify the ItemID_FK (text field) field and check that all the products are present into database before they are imported. I would like to do this to avoid any later database errors at a later stage or user level stage.
I have imported all the data to new table tblInvDetImport having a field ItemID_FK (Which needs to be checked). tblItem having ItemID_PK is the table with which the data needs to be cross checked.
Any ideas or help would be greatly appreciated.
Thanks and Regards
Deepak Gupta