Confguration file for export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank you for your help Tina, but I still want to know where access stores
the output format.
 
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.
 
Back
Top