<div>
You &quot;can&quot; link Excel directly to Oracle using ODBC but I would save it to a CSV and use SQL*Loader.<br />
<br />
If you have SQL Developer or Toad, I've read they can go straight from Excel to Oracle using their import features but I've never used them.
</div>


You "can" link Excel directly to Oracle using ODBC but I would save it to a CSV and use SQL*Loader.

If you have SQL Developer or Toad, I've read they can go straight from Excel to Oracle using their import features but I've never used them.

<div>
I am using Sql Developer . But it fails for huge number of rows
</div>


I am using Sql Developer . But it fails for huge number of rows

<div>
How exactly are you importing the data and how is it not successful?<br />
<br />
Are the rows that aren't imported those where the Location field/column is empty?
</div>


How exactly are you importing the data and how is it not successful?

Are the rows that aren't imported those where the Location field/column is empty?

<div>
Yes, please explain &quot;fails&quot;.<br />
<br />
I would save to CSV and use SQL*Loader.
</div>


Yes, please explain "fails".

I would save to CSV and use SQL*Loader.

<div>
Have you tried SQL Loader? &nbsp;Did that work, or give you errors? &nbsp;Or, did you solve this problem some other way? &nbsp;Or, are you still looking for other help?
</div>


Have you tried SQL Loader?  Did that work, or give you errors?  Or, did you solve this problem some other way?  Or, are you still looking for other help?

<div>
<div class="content wysiwyg-content">
I have an excel sheet (office 2016) with about 1 million rows &nbsp;with just two fileds DocumentNo and Location ( Document No is about 10 character and &nbsp;Location is about 10-15 character and many locations are blank)<br />
The excel file is about 20MB in size. &nbsp;I am trying to import to an Oracle database ( Server has 32GB RAM) &nbsp;But it is not successful . &nbsp; &nbsp; &nbsp; <br />
Is there a way I can import it?
</div>
</div>


I have an excel sheet (office 2016) with about 1 million rows  with just two fileds DocumentNo and Location ( Document No is about 10 character and  Location is about 10-15 character and many locations are blank)
The excel file is about 20MB in size.  I am trying to import to an Oracle database ( Server has 32GB RAM)  But it is not successful .       
Is there a way I can import it?

Import 1 million row Excel to Oracle

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.