iraklisvai
Member²
Hello, I have an Excel with 1 million rows and I want to load the data to a table I have made. Is this possible?
I think it is better to convert the excel file to a text file and then load the data.
Can PL/Sql Developer help?
I saw a video in youtube and I did it with Text Importer.
So I convert Excel to a tab delimited txt, and I tried to load 700 rows as a sample, not the entire excel.
My txt file contains in some columns, names in Greek Language, eg "Γιώργος" (that is George in English). The problem is that some names are loaded correctly and specifically till row 100. From 100 row until the end, the names in Greek are loaded like Chinese!!!. The txt file is in UTF8. Also there is no option for a log file. I have PL/SQL Developer ver 10.
Thank you.
I think it is better to convert the excel file to a text file and then load the data.
Can PL/Sql Developer help?
I saw a video in youtube and I did it with Text Importer.
So I convert Excel to a tab delimited txt, and I tried to load 700 rows as a sample, not the entire excel.
My txt file contains in some columns, names in Greek Language, eg "Γιώργος" (that is George in English). The problem is that some names are loaded correctly and specifically till row 100. From 100 row until the end, the names in Greek are loaded like Chinese!!!. The txt file is in UTF8. Also there is no option for a log file. I have PL/SQL Developer ver 10.
Thank you.
Last edited:
