R rohanale Member² Oct 7, 2015 #1 Hi, I just tried to import an Excel spreadsheet using the ODBC Import tool in PL/SQL Developer. The spreadsheet has about 300 columns. When I imported not all the columns were imported. Is there a limit to the amount of columns you can import? Thanks Rohan Last edited: Oct 8, 2015
Hi, I just tried to import an Excel spreadsheet using the ODBC Import tool in PL/SQL Developer. The spreadsheet has about 300 columns. When I imported not all the columns were imported. Is there a limit to the amount of columns you can import? Thanks Rohan
Marco Kalter Administrator Staff member Oct 8, 2015 #1 I'm not aware of any limitations. Do you see all columns with data in the preview?
R rohanale Member² Oct 8, 2015 #1 Hi, No all the columns do not show on the preview. Only about 200 of the columns show. The other 100 are missing. When try and import the same file saved as a CSV file, PL/SQL Developer thinks there are only 2 columns in total and not the 300 expected. Thanks Rohan
Hi, No all the columns do not show on the preview. Only about 200 of the columns show. The other 100 are missing. When try and import the same file saved as a CSV file, PL/SQL Developer thinks there are only 2 columns in total and not the 300 expected. Thanks Rohan
