I'm working on a project which requires me to import a few hundred Excel worksheets into one Access table. Is there any was to automate this task, rather than using the import wizard each time?
The excel worksheets has approx. 30 fields (columns) each and are named tmprecs01-300, tmprecs02-300, tmprecs03-300, tmprecs04-300..... tmprecs-254-300.
Is this possible? Thanks