Re: [Squirrel-sql-users] Data Import plugin - database error loading CSV file

[Brian M. <bd...@bu...>]

On Fri, Sep 05, 2014 at 05:17:41PM +0000, Alexandre Peshansky wrote:
> There's no default setting, AFAIK - CSV file will reproduce the format you set up in Excel (if you started with Excel and save as CSV).  I usually use mm/dd/yyyy format, so this is what I change it to.  But you can format column (select column, then "Format Cell") with dates to yyyy-mm-dd hh:mm:ss (custom formats, enter manually) and avoid changing format on the DataImport.

I would also look at strings.  The best idea there is to make sure that
they are all quoted.  Some CSV file "generators" don't do that, and some
file readers don't like that.


Brian