Export delimiters/decimals

A

Andy

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.
 
A

Andy

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
 
Top