From: Brig Siton on
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


From: Paul Shapiro on
"Brig Siton" <bnospamsiton(a)yahoo.com> wrote in message
news:uIiQgfQ0KHA.3652(a)TK2MSFTNGP04.phx.gbl...
> 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.

From: Risse on

"Brig Siton" <bnospamsiton(a)yahoo.com> kirjoitti
viestiss´┐Ż:uIiQgfQ0KHA.3652(a)TK2MSFTNGP04.phx.gbl...
> 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
>