View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cats_five cats_five is offline
external usenet poster
 
Posts: 1
Default CSV - no delimiter at end of line

If I have a spreadsheet like this:

fred joe harry

And I save it as a CSV I get this:
fred,joe,harry

Now I want to import the file into a database that requires this e.g. there
is a delimiter after the last field:
fred,joe,harry,

Can I make Excel do this without using a dummy column?
The dummy column solution: e.g.
fred joe harry dummy