Export from Access to Excel

[Mklhayes]

I need to export a table, and add it to an existing Spreadsheet without replacing any information in the existing spreadsheet. The export seems to replace the entire file with the one sheet, and I can not open the spreadsheet file.

 

[WillYum]

Hmmm, that seems like a tough task you have there. Is there any other way you can concieve of tackling your task, cause without some serious programming I don't know how this can be accomplished.

- William ~^~ ~^~

~ W . I . L . L . Y . U . M ~
wOrLd WiDe WhAt?

 

[gmireles]

You can try exporting your access file onto your desktop then copying the data from there and pasting it onto your exisitng spreadsheet.

 

[Mklhayes]

Thank you for your help, I'll try it.

 

[batteam]

If you're using the transferspreadsheet function in Access, you will not be able to export data to an existing spreadsheet. Just one of the limitations of the export parameter of this command.

What you could do is, in your Excel spreadsheet, use the Get External data function. From the toolbar: |Data|Get External Data|New Database Query|. Its a wizard that creates a query that will let you bring in data from any table in any Access db. It does work very well. And, once the 'import data query' is saved, you can execute it with a macro from Excel, if you want. Might take a little bit of practice though, to get the data you want and to know where everything is saved. But I have had good luck with importing data this way. Of course, your users will have to get into Excel to start this process. If you have to have this whole process start in Access, you probably would have to have Access open the Spreadsheet then on the WorkBook_Open event you could execute the macro to run your get data query.

Hope this helps. Good luck.