Discussions
Categories
- 384.5K All Categories
- 2.5K Data
- 552 Big Data Appliance
- 1.9K Data Science
- 451.3K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 560 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 166 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 531 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
How to read excel data and insert into table using PL/SQL procedure
Hi All,
Oracle Database Version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Requirement: I have an excel file with some data in it. I want to read the excel file and eventually insert data from my excel file into the database table using Oracle PL/SQL procedures/functions. Is there any solution to my requirement.
Please note the data is present in the excel file with .xlsx extension, and not .csv.
Thanks & Regards,
Susanto Paul
Best Answer
-
Odie's Exceltable, best solution out there.
Answers
-
Paul Susanto wrote:Hi All,Oracle Database Version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bitRequirement: I have an excel file with some data in it. I want to read the excel file and eventually insert data from my excel file into the database table using Oracle PL/SQL procedures/functions. Is there any solution to my requirement.Please note the data is present in the excel file with .xlsx extension, and not .csv.Thanks & Regards,Susanto Paul
Oracle has no built in capability to read raw *.xlsx formatted files.
Excel when properly configured with ODBC can issue SQL directly against Oracle database.
BTW any PL/SQL solution reads the OS file to reside on the Oracle DB Server system itself & not on some remote client system
-
Sure - just read the FAQ for how to read/process Excel data.
That question has been asked and answered many times on the forum and the FAQ has an entry that explains it.
-
You can connect to the Excel file as if it is an Oracle Database by using Heterogeneous Services (Oracle Gateway for ODBC).
That way you can access the Excel contents and treat it as an Oracle database.
The ODBC Gateway is free (no extra cost) and simple to configure and use.
-
Is this just a one off thing? If so, most client tools such as Road, SQL developer etc have this functionality built in.
-
Odie's Exceltable, best solution out there.
-
Is this just a one off thing? If so, most client tools such as Road, SQL developer etc have this functionality built in.
You mean Toad, right?
-
Of course! Victim of phone autocorrect!
