Bad data on TransferText to csv file

[kmurtha]

Hello.

I am not get test data when I tranfer from a table to a csv file. I am get exponential notation rather than the true text. What am I doing wrong?

Here is the command I am using.
DoCmd.TransferText acExportDelim, "", "NevWkTable", "C:\Documents and Settings\kpm007\My Documents\Test.csv", False, ""

Here are the results(the errors are in bold) as they appear in Excel
5 1111111111 Sally Smith 1.11111E+18 D 1.11111E+34 A 9/21/2004 0:00 9/21/2004 0:00
6 2222222222 Jim Jones 2.22222E+18 S 2.22222E+34 A 9/23/2004 0:00 9/23/2004 0:00
7 3333333333 alan adams 3.33333E+18 s 3.33333E+34 S 9/23/2004 0:00 9/23/2004 0:00


Thanks for your help

 

[Norie]

I don't think it's a problem with the export from Access it's more likely a problem with Excel.

Why not export as text? Then when you import into Excel you can decide how each field is dealt with.

At the moment Excel is 'seeing' the field you are having problems with as a number, and that's why you are getting the exponential.