CSV - no delimiter at end of line

  • Thread starter Thread starter cats_five
  • Start date Start date
C

cats_five

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
 
Try putting a space (hit the space bar once) in the last column first row and
copy down the same...before saving to csv
 
Back
Top