Hi all,
as the title says i want to create a script that will import all excel files in a give directory and put them all into 1 temp table within access. All the excel spreadsheets are in exactly the same format.
I can import a single spreadsheet into access no problems but as far as i can see the doCmd.TransferSpreadSheet command is for a single spreadsheet and im gonna try and put it into a loop but im positive there must be a better way to do this.
anyhelp is much appreciated!
Cheers
as the title says i want to create a script that will import all excel files in a give directory and put them all into 1 temp table within access. All the excel spreadsheets are in exactly the same format.
I can import a single spreadsheet into access no problems but as far as i can see the doCmd.TransferSpreadSheet command is for a single spreadsheet and im gonna try and put it into a loop but im positive there must be a better way to do this.
anyhelp is much appreciated!
Cheers