Transfer Text Method

[WAR40K]

I've run into a problem where I have two requirements for a *.csv file created from an access table. First, I need it to be comma delimited, without quotes around text fields, and secondly it needs to be a fixed width. With the TransferText method it seems I can do one or the other using the export specification, but not both.

In addition, when I export the text file the specification drops leading zeros and truncates decimals to two decimal places.

For example, I have a field with a value of 001 and another field with a value of 29.0000. I need to keep the numbers as formated but the resultant text file will display them as 1 and 29.00 respectively. Is there any way to preserve the formatting and have a fixed width, comma dilimited file without text identifiers?

Thanks

 

[JerryKlmns]

Have you tried to export a formated query?

SELECT FORMAT("1", "0000"), .....
FROM myTable;

Should read

0001,......

 

[WAR40K]

Thanks, I'll give that a try. Last night I discovered that part of my problem was with field type. I converted all my numbers to text so the export wouldn't try and "correct" my output values.