Export to Excel

[gdboling]

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.

[Brian Swann]

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

[gdboling]

how and where do you do that?

[gdboling]

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.

[Brian Swann]

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. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

[Brian Swann]

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.

[gdboling]

That will work. Thanks for you help!!!

[Shane Sargent]

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