Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Microsoft Access 2013 append data to Excel and/or CSV

Posted on 2013-06-08
6
Medium Priority
?
2,290 Views
Last Modified: 2013-12-12
Hello,

I'm using Microsoft Access 2013 over a network.
There is an option in Access that allows you to export data from a query into an Excel file using a wizard.  This option works fine for me.  However, after the export, I would like the option to return later and append data to that same Excel file.

In other words, let's say the data exported looked like this:

Dog
Cat
Mouse

I want Access to bring up this same query at a later date with updated information and append it to that same Excel file.  So if the most recent data added to the table/query included "Elephant" and "Snail", the same Excel file will now look like this:

Dog
Cat
Mouse
Elephant
Mouse

Is there a way to do this using the current Access options, or does it have to be done another way somehow?

Thanks.
0
Comment
Question by:--TripWire--
[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
  • 2
  • 2
6 Comments
 
LVL 40

Expert Comment

by:als315
ID: 39232504
You can't do it without VBA, where you can open Excel or csv file and append data.
0
 

Author Comment

by:--TripWire--
ID: 39232539
In that case, is there a button that I can add to my DB that will mock the export action and add an append feature?
What would that look like?
0
 
LVL 40

Expert Comment

by:als315
ID: 39232553
No, there is no ready button, you should code it in VBA. If you upload sample of your files, we can do it. Csv is text file and code will be like this one:
#a38181469
0
Docker-Compose to Simplify Multi-Container Builds

Our veteran DevOps Author takes you through how to build a multi-container environment, managed with a single utility in order to simplify your deployments.

 
LVL 51

Accepted Solution

by:
Gustav Brock earned 1080 total points
ID: 39232557
It would be easier to have a local Access table where you append the data.
Then, when needed, export that table with the full dataset to Excel. It will then overwrite a previously created worksheet.

Do have in mind, that Access will always export to the firstly created worksheet of the Excel workbook no matter where this later may be positioned. Thus, if you create a second worksheet and move that to the first position, Access will now export to what looks like the second worksheet.

/gustav
0
 

Author Comment

by:--TripWire--
ID: 39250426
Thanks Gustav.
Is there a way to place a macro button on the toolbar menu, so that the user who views the report can just click a button to do this?
0
 
LVL 51

Assisted Solution

by:Gustav Brock
Gustav Brock earned 1080 total points
ID: 39250572
That would be to the ribbon, but that's not so very easy:

http://msdn.microsoft.com/en-us/library/office/ff196428.aspx

I would find another route like one button to open the report, another to run the export.

/gustav
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

722 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