Exporting to Text File

[blandow]

Hello,

I imported an excel spreadsheet which is also now a linked table.

All the data looks great, but now I need to export to a text file, fixed width, and it is not formatting the fields the way that they appear in excel or access. Here is what it should look like:


field 1:



2565350


field 2:

83322015524990

Here is what ends up on the text file

field 1:
2565350.00


field 2:
3.8332201552499e+14


I have reformatted the cells in Excel every which way I can think of, but it always comes out like this.....There is actually a 3rd field which shows data such as: 42.33 and it comes out just fine formatted as text......Help?

[trb5016]

First off, two questions. What type of data fields are these values being stored as? Also, Is that a typo for the two Field 2s?

(83322015524990 changes to 3.8332201552499e+14)

If it's not a type I have no idea where that extra 3 is coming from, but I would venture it has something to do with a weird data type conversion *shrug*

Anyways!

I'd look in to the Round() and Format(). If your numbers are actually whole numbers don't worry about round.

Try something like

'This says to display only numbers to the left of the decimal place
strOutput = Format([Field 1], "0")

[blandow]

It was a typeo. Bottom line is that the numbers are just a long string and they keep going into scientific format. I will post a screenshot