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.
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.