Export Secifications

[acct98]

Does anyone know how to create the export specification [fixed width] for a text file? I would like to insert spaces between certain fields. In addition, I do not want quotation marks around the text fields. Any help would be greatly appreciated.

 

[jebry]

Hi!

Click on the table or query you want to export and choose File/Export. In the dialog box that follows you will need to select the file type as text files. The export wizard will come up and you will want to go to advanced. In the advanced dialog box you can select fixed width and choose the exact start and end points for each field. Another thing I like to do is base the output on a query and format the fields the way I want them, such as:

NewTextField: Format([MyTable]![MyTextField], " &quot
NewTextField2: Format([MyTable]![MyNumeric], "0000000000&quot

These will add leading spaces or zeroes.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[GDGarth]

Another way to do this is to create a report with the correct formatting, then use the DoCmd.OutPutTo method to create a text file. This is handy if you want to do this routinely (although you could also just output the query, as suggested by jebry).

 

[skd2726]

I tried the suggestion from jebry on Sep 30, 2002

NewTextField: Format([mytable]![mytextfield]," &quot
and also the leading zeros one

the leading zeros works fine, but I can't get it to put in the leading spaces...

here's what I used

newreason: Format([table1]![reason]," &quot

Original Reason: abcde

I still get "abcde"
I want " abcde"

(without quotation marks of course)

can someone tell me what I'm doing wrong