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

  • Thread starter Thread starter Brig Siton
  • Start date Start date
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
 
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.
 
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...
 
Back
Top