OraFAQ Forum: Client Tools » Cnnot import more than 65536 rows from excel

Home » Other » Client Tools » Cnnot import more than 65536 rows from excel (Oracle 11g, SQL Developer, Version 3.2.20.09)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cnnot import more than 65536 rows from excel [message #604027]

Mon, 23 December 2013 03:19

mokarem
Messages: 109
Registered: November 2013
Location: Dhaka

Senior Member

Import discarded automatically after 65536 rows are inserted using SQL Developer. How to resolve this issue?

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604029 is a reply to message #604027]

Mon, 23 December 2013 03:28

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

This has nothing to do with Oracle. All you need to do is upgrade your MS office to a latest version.

AFAIK, Excel 2010 can handle 1,048,576 rows.

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604031 is a reply to message #604029]

Mon, 23 December 2013 03:38

mokarem
Messages: 109
Registered: November 2013
Location: Dhaka

Senior Member

I am using Microsoft Excel 2010. In excel sheet I have generated 250000 rows. But after importing 65536 rows , its discarded automatically.

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604032 is a reply to message #604031]

Mon, 23 December 2013 03:45

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

65536 rows

Which is the limit for an Excel sheet as far as I know.

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604033 is a reply to message #604032]

Mon, 23 December 2013 03:48

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry, I am wrong, from Excel specifications and limits

Quote:

Worksheet size 1,048,576 rows by 16,384 columns

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604034 is a reply to message #604032]

Mon, 23 December 2013 03:50

mokarem
Messages: 109
Registered: November 2013
Location: Dhaka

Senior Member

@Michel Cadot

In an old version of MS Excel that was the limit.

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604035 is a reply to message #604033]

Mon, 23 December 2013 03:52

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Searching a little bit more, Excel 2010 Performance: Performance and Limit Improvements says this is part of "Big Grid" feature which needs the following:

Quote:

To use these new features, you must update your XLL functions. For more information, see Developing Excel 2010 XLLs. If you do not update your add-in functions, they will continue to work, but they will be unable to use the new features introduced in Excel 2007.

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604037 is a reply to message #604035]

Mon, 23 December 2013 04:32

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

You could save them as a csv and use sql*loader.

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604041 is a reply to message #604035]

Mon, 23 December 2013 04:52

mokarem
Messages: 109
Registered: November 2013
Location: Dhaka

Senior Member

Thanks All!

I have converted the excel to CSV file and now importing is going on.........and processed rows already crossed the limit 65536.

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604064 is a reply to message #604031]

Mon, 23 December 2013 07:28

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

mokarem wrote on Mon, 23 December 2013 15:08

I am using Microsoft Excel 2010. In excel sheet I have generated 250000 rows. But after importing 65536 rows , its discarded automatically.

And I don't believe that,

Lalit Kumar B wrote on Mon, 23 December 2013 14:58

This has nothing to do with Oracle. All you need to do is upgrade your MS office to a latest version.

AFAIK, Excel 2010 can handle 1,048,576 rows.

Report message to a moderator

Re: Cnnot import more than 65536 rows from excel [message #604067 is a reply to message #604064]

Mon, 23 December 2013 08:00

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

I do - he's using sql developer, wouldnt surprise me if a legacy limit exist(ed?). It's not the DB discarding rows, it'll be the automated import Smile

[Updated on: Mon, 23 December 2013 08:00]

Report message to a moderator

Previous Topic:	package
Next Topic:	TOAD table/procedure content display problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 16:18:22 CST 2025