One Star

excel to postgresql string

Hello
I am having problems with excel tables import to tpostgresql.
I set the type of data to Double or Float and he reports error
statistics] connecting to socket on port 4270
connected
For input string: "7410,42"
For input string: "7410,42"
For input string: "14820,83"
disconnected
Than I set type of data to BigDecimal and now he reports this error
statistics] connecting to socket on port 4008
connected
null
null
null
disconnected
Job dohlestvica ended at 16:25 16/11/2009.
What type of data is set in excel (text, number, general) doesn't seem to have any effect
This problem occurs almost every time I am dealing with decimals
Any suggesttions???
thank you for helping me
2 REPLIES
Community Manager

Re: excel to postgresql string

Hello
For input string: "7410,42"

Read it as string type, then remove the comma ',', convert string to double or float as needed.
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: excel to postgresql string

Thank you
The problem is with dot and commas. Because european is 790,12 but when you transfer to postgreSQL it is suppose to be 790.12, so you have to change it in excel. But since Microsoft is ..... sometimes you have big big problems with replacing that. Open office rulesSmiley Happy