HI
I have created a payment an invoice database to take over from excel spreadsheets. The problem is each contractor has a "curent balance" excel workbook. There are 671 work books to import into a temporary table. I only need Sheet1 of each workbook. All the workbooks are named after the contractor and are all stored in the same file.
Is there a way to import them in bulk or do I have to do each one manualy?
Any help or if anyone knows of other resources that I can look at it would be much appreciated.
Thanks
I have created a payment an invoice database to take over from excel spreadsheets. The problem is each contractor has a "curent balance" excel workbook. There are 671 work books to import into a temporary table. I only need Sheet1 of each workbook. All the workbooks are named after the contractor and are all stored in the same file.
Is there a way to import them in bulk or do I have to do each one manualy?
Any help or if anyone knows of other resources that I can look at it would be much appreciated.
Thanks