Chris_James3
·
Jun 12, 2022
Roberto was great...
My project involved Developing Business Software using the Microsoft Access Software Developer's Kit. Roberto has worked with Microsoft Access for many years so he was the right choice for my project.
Roberto used Access VBA to work with our multiple external text files (1000-3000 files) that my project needed to manipulate. His VBA had to target specific data within each file, including renaming the file, checking each file for internal data errors, trimming out unnecessary data, and importing each text file's data into my Access accdb database... and doing this using the right import specifications and the proper looping code.
He consulted with me on risk management in my project that I was not aware of.
He also initiated err handling code... Specific to each workflow, in his VBA code, for every event and if there was an error that took place, when the code ran, he recorded it in my database in a table called tbError. He did this so we can look at that table after the import ends to see all the code event history.
I highly recommend Roberto Motto.
for
Access VBA Read/Write/Import Text File