|
From: Alexandre P. <Ale...@ei...> - 2014-09-05 16:49:52
|
I usually see that when I forget to modify the CSV defaults, especially date format. -- 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 12:20 AM To: squ...@li... Subject: [Squirrel-sql-users] Data Import plugin - database error loading CSV file I've got the Data Import plugin loaded and supposedly working, but when I try and fill a table with a CSV file I get "A database error occurred while inserting data" During the data insert process, I see the full preview of my CSV data correctly, and it reads the column names and rows and everything just fine. It's only when I say "go ahead and create it" that it crashes. This question's been asked before, but not since ~2008 and it was never answered fully then, so hopefully we can figure it out this time. I'm a new user to SQuirreL SQL, and trying to get it set up to load in a fairly large data set (currently in .dat format). |
