• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 709
  • Last Modified:

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?
0
panrob
Asked:
panrob
1 Solution
 
chapieCommented:
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now