Import Workbook via code or macro
Posted on 2002-05-30
Hi. I have an Excel 97 workbook that contains several spreadsheets. I need to import all of the spreadsheets into an Access table. Does anyone know how to do this? When I create a macro and use transfer spreadsheet, it only imports the first spreadsheet in the workbook. I have tried using the "range" criteria, however, I don't know what the end of the range would be for the spreadsheet. I also only to import those records that have the column CurrentDate value of today's date.
Thank you for any help!