I'm doing a lot of bulk import using CSVs. One thing I've found is that, if there's a row in the CSV with bad data, the remainder of the row is not imported. That is, if we are expecting 5 doubles in our target table, and our input CSV looks like this:
0.12, 12.45,78.12,#DIV/0,45.67 1.0,2.0,30.12,4.5,67.0 Etc... Then the fourth and fifth column of the first row are imported as 0, without raising an error. The second row imports properly, and so on. Is there a known cause for this behavior, and can it be corrected? -- ======================= Personal Blog: http://www.xanga.com/lizard_sf Facebook: http://www.facebook.com/lizard_sf MrLizard: Gaming and Geekery: http://www.mrlizard.com -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
