I have a folder of ~20,000 excel files .xlsx extension that all have a common header and are roughly the same size. I would like to import all of these files into an access database. I attempted to write a macro/module in access and have searched the web for example code, all of the example code seems to be for 2007 version of office which has macro commands that aren’t supported in 2010 version.
I was able to get my VBA code to the point of opening the file and looping through the folder however finding a command to place it into access is problematic since the only one I found is a 2007 command….
If anybody has any ideas or skills in Access 2010 please let me know.