<div>
<div class="content wysiwyg-content">
I would like to build something that will take information from excel into Access.<br />
<br />
My excel sheet will have one column of &quot;BookingNumbers&quot;. I have an access table that has &quot;BooingNumber&quot; as the primary identifier. &nbsp;It also has a &quot;Yes/No&quot; field called &quot;Finished&quot; on that table.<br />
<br />
If the &quot;BookingNumber&quot; is listed in the excel column. I want the Access table to change the &quot;Finish&quot; value to &quot;Yes&quot;.<br />
<br />
I will be doing this multiple times a day, so I'd like it to be relatively quick and accurate. Any ideas?
</div>
</div>


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?

Excel info to access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.