SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Import wizard convert decimal point to comma when imported from xlsx file

anishjpAug 3 2023 — edited Aug 3 2023

Hi Guys

I am using Oracle Database 18c Express Edition 18.4.0.0.0 and SQL Developer Version 23.1.0.097 Build 097.1607.

I have a Microsoft 365 Excel Worksheet (xlsx) file with numbers that have decimal point.

When I import the xlsx file to the database using the import data wizard, the decimal points are converted to comma's.

The format of the cell in xlsx file is “number” in (-1023.10) fomat and I have selected format: excel 2003+ (xlsx) in the data preview page of the import wizard still all decimal points are converted to commas.

How do I fix this? Please let me know if you need more info.

Regards,

Anish

Added on Aug 3 2023

#sql-developer

6 comments

1,385 views

1 mention