Export to Excel

Topic

New Reply

Is there a way to export data in a table to a pre-formated Excel spreadsheet? When I export, it always overwrites the entire Excel file to a new unformated one.

Reply | Quote

Replies

You can export from access (although I never have), I normally import from Access table/queries to pre-formatted excel spreadsheets.

Reply | Quote

how and where do you do that?

Reply | Quote

Once you’ve created your Excel Spreadsheet, select the starting cell location, click on Data|Get External Data|Create New Query (or Run Database Query), and follow the wizard. Once this is done and you’ve saved the xls file you have the option to Refresh the data any time you like. As far as exporting from access to cells in excel, as I say that’s something I believe can be done through code, however I’ve never done it. Hope that helps.

Reply | Quote

cool, thanks, that does help. So refreshing will append data and not overwrite?? Or does it overwite all the cells just not the formatting of them.

Reply | Quote

No, it will overwrite existing data but will leave the formatting alone. Think I see where you’re going, it is undoubtedly possible to append within excel (expand an area in a sheet) but that’s a bit out of my scope. I normally grab summary information from an access query and do my detail work using Access reports.

Reply | Quote

That will work. Thanks for you help!!!

Reply | Quote

You can link to an Excel worksheet and append into it via an append query in Access.

Reply | Quote