Confguration file for export

[Fabio Furukawa]

I'm triyng to export a table and there is a column (number double without
decimals). The format is CSV with field names delimiter = none. But when the
".txt" is generated the column (number double) is always posfixed with ".00".
I remember once I edited a configuration file that had the column names an
format of output. But now I don't remember the name neither where it is.

Please Help

Thanks
Fábio Furukawa

 

[tina]

you could create a Select query from the table, and try either 1) formatting
the number field to no decimal places using the Format() function, or 2)
coercing the field to a Long Integer using the CLng() function. then export
the query, rather than the table.

hth

 

[Fabio Furukawa]

Thank you for your help Tina, but I still want to know where access stores
the output format.

 

[tina]

well, you're welcome, Fabio. sorry i don't have the answer to that question,
but maybe someone else will respond. if no luck after a day or so, suggest
you repost to this ng; there are several very sharp folks who lurk here and
may have an answer for you. good luck with it.

 

[John Nurick]

Schema.ini?

On Thu, 9 Aug 2007 13:30:20 -0700, Fabio Furukawa <Fabio

 

[Fabio Furukawa]

Thats it !!!!!!!

Thanks a Lot John...

Schema.ini?

On Thu, 9 Aug 2007 13:30:20 -0700, Fabio Furukawa <Fabio