Export delimiters/decimals

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

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.
 
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
 
Back
Top