For the past year I have been working on automating the processes for my employer in Excel to reduce the amount of 'human error' analysts put into the data when they move it around. I am over 250 pages of code at this point and am being asked to move it into Access because we are also hitting well over 800k rows of data and might hit the 1 million mark by this time next year.
What sort of differences should I expect to have to learn to code for Access as opposed to Excel?
What the code will need to do:
SQL Data pulls
Forward results into Excel
(the rest I will need to know I already know how to do in Access, so these are the only two new items)
I am presuming I can do these in Access, and can try to guess how they might be done, but I want to hear from those who have already done so if I am going to have a rough time of it or not. Right now I am using SQL drivers in Excel but would LOVE to move to an ADO data pull structure to remove the need for those drivers (if possible).