Hi,
I need to loop through a directory and import all the files with the response sheet of the excel file into a table in access.
my sheet has a questionnaire and a response. When i try to simpley import the file, it imports the questionnaire sheet and gives me errors when I try to specify the Responses sheet. Any suggestions would be must appreciated.
I need to loop through a directory and import all the files with the response sheet of the excel file into a table in access.
my sheet has a questionnaire and a response. When i try to simpley import the file, it imports the questionnaire sheet and gives me errors when I try to specify the Responses sheet. Any suggestions would be must appreciated.
