CJones
Final Approach
I have an Excel workbook with a growing number of worksheets. I would like to be able to import each worksheet into Access as its own table. I can do this manually via the File -> Get External Data... and import each worksheet individually.
Is there a way to import the entire workbook and have the individual tables created automatically? I don't mind if the current tables are overwritten each time the workbook is imported - once the tables are created, I will run a macro of some sort to do some tweaking of the data anyway.
Do I need to sit down and crank out some VBA to do this, or will Excel or Access do this automatically?
Access/Excel 2003.
Is there a way to import the entire workbook and have the individual tables created automatically? I don't mind if the current tables are overwritten each time the workbook is imported - once the tables are created, I will run a macro of some sort to do some tweaking of the data anyway.
Do I need to sit down and crank out some VBA to do this, or will Excel or Access do this automatically?
Access/Excel 2003.