I need to export data from Access into an Excel spreadsheet with special formatting (several columns have drop-down lists, etc.).
Any suggestions on the best way to do this? I know you can create a new Excel spreadsheet through an Access export, but how do you add data to an existing spreadsheet while retaining the formatting of the spreadsheet?
I need a way to do this systematically, since there are about 100 spreadsheets that will need to be regularly updated in this way.
Thanks for your help!