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

[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

 

[Paul Shapiro]

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.

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

 

[Risse]

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