excel to postgresql string

[veryimportantdude]

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

[Anonymous]

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

[veryimportantdude]

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 rules