CODEWITHSUNDEEP
sqloracle-database
Arockia
Arockia

Reputation: 440

What is the maximum row limit for SQL Developer Import excel?

Excel import in sql developer to Oracle DB is not working. Anybody have an idea such that will be there any row limit for a single time import because we have some thousands of records. Please help...

Upvotes: 1

Views: 16450

Answers (2)

Samith C Valsalan
Samith C Valsalan

Reputation: 139

In addition I have experienced Memory issue of while importing a large Excel file.

So Please keep in mind that your server performance also play a vital role in this..

Upvotes: 1

Samith C Valsalan
Samith C Valsalan

Reputation: 139

Sql Server dont have any restriction to export excel.

based on the Excel version your using , the row limit of Excel matters.

in Excel 2010 we have 1048576 row per sheet.

Excel 97 - 65536.

Upvotes: 2

Related Questions