Export Delimted Loses Formatting

[q582gmzhi]

Hi,

I have some data that I need to export to Delimited CSV.

When I look at the data in the table or query its in the correct format that I have created, however when I export using specification file it loses the formatting.

For example the following numerical data goes from the correct format on the left in a table or query, to the wrong format on the right when exported to Delimited CSV

060 > 60
118.80 > 118.8
5550.50 > 5550.5
07072003 >7072003

DoCmd.TransferText acExportDelim, "ResolDataSpec", "ResolData", "C:\HORpts\ResolData.csv", False

I have tried with both a query and from a table, but both lose the formatting on the numerical data?

Any idea's?

Thanks in advance.

Darrell....

 

[RuralGuy]

In order to maintain the format you describe you will need to export then as strings rather than numbers.