Formating changes when exporting

[bravo6]

Wow this is frustrating!
I am trying to export some access query results to a .csv file. In the query a field whose value is always an integer converts to a decimal upon export. For example in the query results the value is "2" upon export it becomes "2.00". I tried doing a "Make Table query" and setting the number format to decimel places 0. I also tried formatting the field as text instead of number but no matter what, upon exporting an integer becomes a number with 2 decimel places.

I also have a similar problem with dates. No matter what I do, when I export a "short date", the time is added to the field. For example the value "10/07/2007" becomes "10/07/2007 0:00:00" when exported.

 

[SkipVought]

Hi,

This is a distinction without a difference.

2 equals 2.0

10/07/2007 equals 10/07/2007 0:00:00

Its ONLY formatting. The underlying VALUES are identical.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[lameid]

Are you sure it is dumping bad data in the CSV file? I mean Excel does all kinds of evil formating things all by itself.

Formats of fields in queries don't export what is exported. However if you use the format function that returns a string/text, the string should get exported with less hassle.

 

[Remou]

Have you tried formatting the query, that is, instead of ThisField, Format(ThisField,"yyyy/mm/dd") or Format(TheInt,"#")

 

[lameid]

Skip,

I aggree but depending on where the CSV is going, having a number with a precision of an integer versus a decimal with 2 places may make a difference.