db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mane_uk <mane...@hotmail.com>
Date Wed, 30 Nov 2011 13:46:11 GMT

Hi Knut Anders,

   First of all, sorry for keeping creating new threads but don't know how
to reply in the same thread. 

   Anyway, based on your last e-mail:

Is the opposite also true? Do every column in the table have a
corresponding field in the csv file? This error message usually means
that there are more columns in the table than in the csv file, in which
case you'll have to use SYSCS_IMPORT_DATA instead and specify which
columns to import.

   The answer is yes... I have created manually the table based on the
column's label so each column in the table should have a correspondent
column in the excel spreadsheet/csv file and vice-versa.

   And i have also tried using the IMPORT_DATA instead of IMPORT_TABLE but
then it gives the following error message:

Exception in thread "main" java.sql.SQLException: Import error on line 1 of
file C:\dev\workspace\aaaatest\TRADEMANAGERXLHEAD_TRADELEG.csv: Invalid
character string format for type INTEGER. 

   Again, the fields were created based on the content of the cells so it is
correct. And I made sure to change the format of the cell to also correspond
to the content. And, in view of the size of the spreadsheet (42k+ rows and
60+ columns) I can't really go row by row checking all the data.

   Anymore ideas please? 

Many thanks
View this message in context: http://old.nabble.com/Error-on-CALL-SYSCS_UTIL.SYSCS_IMPORT_TABLE-tp32884390p32884390.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message