Multiple TransferText to the same File - Need to Append not Overwrite

B

Brig Siton

On Access 2003:

I have a multiple tables that need to export its data on a text (fixed
width) file.

I tried the transfertext macro and the following VB but they overwrite each
other's export.

DoCmd.TransferText (acExportMerge), "MASTER_DELIVERY",
"0001_MASTER_DELIVERY", "C:\Data\testouput.txt", No
DoCmd.TransferText (acExportMerge), "EOB_NON_DETAIL", "0002_EOB_NON_DETAIL",
"C:\Data\testouput.txt", No
DoCmd.TransferText (acExportMerge), "SERVICE_LINE", "0003_SERVICE_LINE",
"C:\Data\testouput.txt", No

I can not use the MakeTable Query to merge the 3 tables into one as they
have different layouts/fields.

Please advise.

Thank you.

Brig
 
P

Paul Shapiro

Brig Siton said:
On Access 2003:

I have a multiple tables that need to export its data on a text (fixed
width) file.

I tried the transfertext macro and the following VB but they overwrite
each other's export.

DoCmd.TransferText (acExportMerge), "MASTER_DELIVERY",
"0001_MASTER_DELIVERY", "C:\Data\testouput.txt", No
DoCmd.TransferText (acExportMerge), "EOB_NON_DETAIL",
"0002_EOB_NON_DETAIL", "C:\Data\testouput.txt", No
DoCmd.TransferText (acExportMerge), "SERVICE_LINE", "0003_SERVICE_LINE",
"C:\Data\testouput.txt", No

I can not use the MakeTable Query to merge the 3 tables into one as they
have different layouts/fields.
Click to expand...

You could export to 3 different files and then concatenate the files with a
dos-like copy command.
 
R

Risse

Brig Siton said:
On Access 2003:

I have a multiple tables that need to export its data on a text (fixed
width) file.

I tried the transfertext macro and the following VB but they overwrite
each other's export.

DoCmd.TransferText (acExportMerge), "MASTER_DELIVERY",
"0001_MASTER_DELIVERY", "C:\Data\testouput.txt", No
DoCmd.TransferText (acExportMerge), "EOB_NON_DETAIL",
"0002_EOB_NON_DETAIL", "C:\Data\testouput.txt", No
DoCmd.TransferText (acExportMerge), "SERVICE_LINE", "0003_SERVICE_LINE",
"C:\Data\testouput.txt", No

I can not use the MakeTable Query to merge the 3 tables into one as they
have different layouts/fields.

Please advise.

Thank you.

Brig
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TransferText to mailmerge file doesn't work 2
Help with Appending to File... 1
Export 3 tables to the same Excel file 0
LINK to the 3 Text Files in a Folder w/o specifying their actual names 0
An error occurred trying to import file 'c:\temp\import.txt'. The file was not imported. 0
Need to update Multiple PivotTables from same sorce 3
How to reduce the size of a file that contains pivot tables 1
Remove Macros before send? & Runtime error if choosing not to overwrite file? 17

Top