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
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..
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:
- Need vbcode to compare excel sheet and access
- Ms access download - Download - Databases
- Mark sheet in excel - Guide
- Google sheet right to left - Guide
- How to open excel sheet in notepad++ - Guide
- How to screenshot excel sheet - Guide
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
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