Hello!
So, I'm currently teaching myself Access as I go along. I have basic VB knowledge as well. The problem that I need to tackle is the following:
I have a table that contains several fields... The 3 that have to deal with this are: Req#, Status, and Status date.
Req number: primary Key
Status: Will Change
status date: Will Change
So, I have a spread sheet from another program that is ran once a week that contains the req# and new status information for those particular requisitions. Rather then going into the table one by one and changing the status and date myself... I want to know if there is a way to set it up to have the spreadsheet with the new information imported into access and automatically change the status information over.
Please let me know if I'm not making any sense... :0)
Thanks!
So, I'm currently teaching myself Access as I go along. I have basic VB knowledge as well. The problem that I need to tackle is the following:
I have a table that contains several fields... The 3 that have to deal with this are: Req#, Status, and Status date.
Req number: primary Key
Status: Will Change
status date: Will Change
So, I have a spread sheet from another program that is ran once a week that contains the req# and new status information for those particular requisitions. Rather then going into the table one by one and changing the status and date myself... I want to know if there is a way to set it up to have the spreadsheet with the new information imported into access and automatically change the status information over.
Please let me know if I'm not making any sense... :0)
Thanks!