Update of Multiple Import Script
Brian Element
Forums
I just posted an update to the script, several things have been added / changed.
KrisW who is a member made some changes to the script so it will now read the new version of MS Access Files and KrisW found a problem that the script wasn't picking up all the different types of excel files in a directory and fixed that. Thanks Kris!!
I also added some code, per a suggestion from Christian, so that the script will now import multiple worksheets from an excel file instead of only the first one. You have the option to either import all the worksheets or only the first one. Thanks Christian for the suggestion.