(Solved) – How to make the search faster? [closed]

  • by
(solved)-–-how-to-make-the-search-faster?-[closed]

I am developing a vba code in MS-Access that does a search in an Excel spreadsheet, searches for the “start of manufacturing” field and fills in access, all based on a common serial number. the question now is how can I make this search faster? because it takes hours to run 100 items, and the spreadsheet has 1800 rows … (Im using the method “FindFirst” to fill up the empty fields)

Leave a Reply

Your email address will not be published. Required fields are marked *