acExportDelim

  • Thread starter Thread starter aMack
  • Start date Start date
A

aMack

There is a code that I would like to duplicate and use for a different table
source but it is not working.

The original code is:
DoCmd.TransferText acExportDelim, "EDI Export Specification", "EDI",
"\\d:\Maersk EDI\Maersk EDI.txt"

I need to make the same kind of export procedure for a different table [EDI
TRAC]

DoCmd.TransferText acExportDelim, "EDI Export Specification", "EDI",
"\\d:\Maersk EDI\EDI TRAC.txt"

The result is empty although the data table is not.

What is, where and how do I design the Export specification?

Thanks
 
You create an Export Specification by manually beginning the export (or
import) process (via File | Export). When you're in the wizard window,
select the ;
character as the delimiter, and set any other settings you want (field
names, data types, etc.). Then, before you click the Finish button, click
the Advanced button at bottom left. In the new window, you'll see all the
settings you've specified. ClickSave As button and save them as an export
specification (name it whatever you want, e.g., "MyExportSpec", for
example). Click OK button to return to the main window of the wizard. Then
click Cancel button
to cancel the rest of the export.

Now go to your TransferText code and add the name of the export
specification to the appopriate argument position.
 
--
A MACKENZIE, CMA, MBA


Ken Snell (MVP) said:
You create an Export Specification by manually beginning the export (or
import) process (via File | Export). When you're in the wizard window,
select the ;
character as the delimiter, and set any other settings you want (field
names, data types, etc.). Then, before you click the Finish button, click
the Advanced button at bottom left. In the new window, you'll see all the
settings you've specified. ClickSave As button and save them as an export
specification (name it whatever you want, e.g., "MyExportSpec", for
example). Click OK button to return to the main window of the wizard. Then
click Cancel button
to cancel the rest of the export.

Now go to your TransferText code and add the name of the export
specification to the appopriate argument position.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


aMack said:
There is a code that I would like to duplicate and use for a different
table
source but it is not working.

The original code is:
DoCmd.TransferText acExportDelim, "EDI Export Specification", "EDI",
"\\d:\Maersk EDI\Maersk EDI.txt"

I need to make the same kind of export procedure for a different table
[EDI
TRAC]

DoCmd.TransferText acExportDelim, "EDI Export Specification", "EDI",
"\\d:\Maersk EDI\EDI TRAC.txt"

The result is empty although the data table is not.

What is, where and how do I design the Export specification?

Thanks
Click to expand...


YESSSSSS!!
Click to expand...

Thank you
 
Back
Top