Export delimiters/decimals

[Guest]

I'm trying to export a table from Access to .csv/.txt format. I'm setting the
delimiter to , and the text qualifier as none. There is a field which for
some rows has a zero in it. Throughout all of the export screens, this entry
is showing as ,0, as I would expect. Once i have exported the file and
checked with notepad, it is showing as ,0.00, which is causing problems with
my batch job for some software.

As ever, any help greatly appreciated.

 

[Guest]

Sorry forgot to mention. If I open the resulting file with Excel and re-save
as a .csv (with no edits), this resolves the problem. I don't however want to
do this as I am trying to set up an automated process!

Thanks

 

[Roger Carlson]

Don't export the table. Create a query and use the Format() function to
format any columns with special formatting needs. Then export the query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L