VBA Appending exported query files via DoCmd.TransferText

P

psycoperl

Active Member
Joined
Oct 23, 2007
Messages
338
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
  3. Web
I have the following command in VBA to export a query to a csv file

Code: 
DoCmd.TransferText acExportDelim, "SimNetRegistrationRosterExportSpecification", "z_SimNetRegistrationRoster", _
    RegToolPath & RegToolPrefix & Format(Now(), "YYYY-MM-DD_HHnn") & ".csv", True
[code]

I need to append to the file that was created the in that last command the data created by the following z_SimNetOSSDRegistrationRoster query. How can I do this?

Thanks
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Sort by date Sort by votes
Appending is not easy to do with TransferText (maybe not possible). Generally you need to use file I/O code to do that.

This article shows one way to write text files using the FileSystem Object.

Possible strategy:

Create the new file using TransferText
Use the FSO to append the new file to the main one

Denis
 
Upvote 0
As they were variants of the same query. I just made a union query and exported those results.
 
Upvote 0
Yep, that's the way to go in that situation. I was unclear whether both data sets were live, or you were appending one export to a pre-existing file.

Denis
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Export To Excel .XLSX file
Replies
3
Views
210
Micron
M
S
  • Solved
Export Access Table data to Excel - DoCmd.TransferSpreadsheet function
Replies
3
Views
614
alansidman
A
M
  • Question
Access exporting text files with variable file names
Replies
5
Views
940
Micron
M
Anigito
  • Solved
MS Access Union Query Changes Numeric values to Text values
2
Replies
11
Views
815
Anigito
Anigito
S
  • Question
ACCESS, VBA: Fetch data from sql server and paste it into local table.
Replies
3
Views
736
Micron
M

Forum statistics

Threads
1,214,565
Messages
6,120,254
Members
448,952
Latest member
kjurney

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top