Export text file problem

[Krell48]

I have an application where I need to export a "^" delimited text file for use in another program. The problem is one of the fields is numeric and the output text file has small numbers converted to scientific notation. I have tried changing field lengths, converting the field type to text, limit decimal places all to no avail.

Any suggestions?

 

[wemeier]

Are you sure the export is creating scientific notation? Or could it be the program you're reading the delimited file into is converting it to scientific notation? Have you looked at the delimited file with NotePad or WordPad to see what it looks like?

If you are exporting data as a delimited text file your numbers should remain intact.

 

[Krell48]

Yes, I have looked at the file with notepad. The input looks like this 0.007999999 and output like ^7.999999E-03^.

 

[wemeier]

Try exporting the file using the export wizard. During the wizard, click on the Advanced tab. Make sure that the field in question is described as Double. If not, change it and save the export spec.

 

[slpluim]

If you are using Office 2000 be sure you have service pack 3. That fixed the problem for me