Hey
I want to import data from an MS Access Database to a specific worksheet in my Excel spreadsheet.
Any ideas for going about this?
Printable View
Hey
I want to import data from an MS Access Database to a specific worksheet in my Excel spreadsheet.
Any ideas for going about this?
In one one my databases I use a two step approach, I export from the database to a spreadsheet. The spreadsheet is then linked to a specific worksheet in another spreadsheet. The second spreadsheet has other worksheets linked to other spreadsheets to give the overall result.
I do not know if you can export from a database to specifi worksheet in a spreadsheet.
Allan