I know that when I create an External Data Import from an Excel Workbook I can define which worksheet I wish to use.
My current problem is that I have a Workbook with four Worksheets, three of which feed (append) data into different Tables in my database. The 4th one supplies the data.
How do I import from the correct worksheet using ImportExportSpreadsheet? Or is there an alternative way. I need the macro so that it can be a Menu driven option.
Help, please!