Re: [Squirrel-sql-users] Data Import plugin - database error loading CSV file
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Alexandre P. <Ale...@ei...> - 2014-09-05 17:17:56
|
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. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore Albert Einstein College of Medicine 1300 Morris Park Ave, Bronx, NY 10461 (718) 430-2440 (Mo, Tu, Th, Fr) (718) 920-4885 (We) -----Original Message----- From: cassandracyril [mailto:cas...@gm...] Sent: Friday, September 05, 2014 1:13 PM To: squ...@li... Subject: Re: [Squirrel-sql-users] Data Import plugin - database error loading CSV file Thanks - sorry if this is a silly follow-up, but what do you modify it to? What is the default date setting in Excel CSV? Given that I don't even have any dates in this sample dataset, it's hard to see what it wants to be reading. -- View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Data-Import-plugin-database-error-loading-CSV-file-tp3403p3407.html Sent from the Users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |