Creating TransferText specification?

[pdbowling]

Hi all,
I'm trying to create a new TransferText specification for a fixed width export but the help files are not helpful.

I know the fixed width format I need and how to use the wizard, I just need to know how to navigate the menus to get to the place where I build it.

Thanks everyone.
PB

 

[jebry]

Hi PB!

From the start:

Select the table or Query you want to export.
Click File/Export.
In the Save As File Type choose Text files.
When the wizard comes up check the fixed width check box and click Advanced.
In the advanced screen go to the bottom area where the fields are and type in the start position and length for each field.
Click on the Save As button and choose the name for the specification file.
Now click OK and then OK again.
If you don't want to export now, just cancel the operation because the specification file is already saved and can be used in the TransferText Action or Method.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[vbajock]

Files, Import, choose txt,csv etc from pull down. When wizard starts, look for Advanced button. Screen pops up, type spec into it, save it using save as, make a note of spec name if you are going to use it elsewhere, or you can find list of specs in the same Advanced screen under Specs button

 

[tlaksh]

I am using the following command to export data

DoCmd.TransferText acExportDelim, "HourSpec", "HoursData",
filename, True

When I run the query HoursData the following result is displayed on screen

Actual DOLLARS.INPUT 1000111TA 61056 01420000 d 20040011 15.50

but the actual text file looks like this

Actual,DOLLARS.INPUT,1000111TA,61056.00,01420000,s,20040011.00,22.50

Can anyone please let me know how I can get rid of the decimal places in 61056.00 and 20040011.00.

Thank you
Lakshmi.

 

[jebry]

Hi!

In your query you can use CInt(YourField) or possibly Format(YourField, "00000000")

hth


Jeff Bridgham
bridgham@purdue.edu