Need vbcode to compare excel sheet and access

Closed
mohan - Jun 20, 2010 at 12:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 20, 2010 at 05:45 AM
Hello,
I have one excel sheet, data of material receipts which is maintained by warehouse, ID is purchase order Number which is unique, and another is Access table, where it is maintained by purchase department, monthly once i need to update my access table with material recept date against each purchase order. purchase order number is the same for excel sheet as well as my access database. checking excel sheet with the help of purchase order number and get the material receipt date and update in my access database. kindly help me with code..


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 20, 2010 at 05:45 AM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0