Does anybody know how I can import excel files from subfolders within a top level folder? What I am trying to do is: a user will choose the folder where the subfolders are, then when a user clicks "import", all the excel files within the subfolders will be imported into Access. I've tried using the DIR function, but I haven't gotten it to work. Thanks for your help
Ramon
Ramon