Solved

Transfer Spreadsheet Action

Posted on 1998-01-12
2
702 Views
Last Modified: 2012-08-13
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
Comment
Question by:panrob
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
chapie earned 100 total points
ID: 1965307
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
 

Author Comment

by:panrob
ID: 1965308
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question