Prev: forwording email with only my email address
Next: why is it saying program has expired when i just downloaded
From: Brig Siton on 31 Mar 2010 15:25
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 1 Apr 2010 06:57
"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 2 Apr 2010 02:51

"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
>


 | 
Pages: 1
Prev: forwording email with only my email address
Next: why is it saying program has expired when i just downloaded