Excel info to access
Posted on 2014-03-10
I would like to build something that will take information from excel into Access.
My excel sheet will have one column of "BookingNumbers". I have an access table that has "BooingNumber" as the primary identifier. It also has a "Yes/No" field called "Finished" on that table.
If the "BookingNumber" is listed in the excel column. I want the Access table to change the "Finish" value to "Yes".
I will be doing this multiple times a day, so I'd like it to be relatively quick and accurate. Any ideas?