Transfer Spreadsheet Action

Need to transfer Access data to an Excel spreadsheet file on a server.  When I send the query results to the file, it replaces the information that was in that file previously.  Is there a way in VBA to append the information to the Excel file?  Do I have to send it to a different file each time in the same folder/directory perhaps?
panrobAsked:
Who is Participating?
 
chapieConnect With a Mentor Commented:
I've never had to append an Excel file before, always just replaced, but I would imagine you can create a linked table to the spreadsheet file, then create a temporary table run an append to the temp table, adding the current spreadsheet info, then add the table/query you want to the temp table, then do your transfer over the .xls file, at least that's how I would attempt it, maybe someone else has a better solutino
0
 
panrobAuthor Commented:
I hadn't thought of linking because I am exporting crosstab query results.  Haven't had a chance to see how appending works but I'll give it a whirl.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.