This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes populate data from csv into oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "populate data from csv into oracle" Watch "populate data from csv into oracle" New topic

populate data from csv into oracle

Sam Venkata
Ranch Hand

Joined: Mar 06, 2006
Posts: 68
I have a csv file and I need to populate the data into an oracle table.
The csv is in the form of excel sheet.
I tried to import the data from excel into MS Access and then export the same into oracle database but all the data is stored in the form of varchar(ex: number field in access is being stored as varchar in oracle table).
is there any thing that I could to keep the data type and still export the data to oracle table?

Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30353

Welcome to JavaRanch!

Going back a step, are the data types correct in Access?

Another approach that doesn't involve the intermediate Access is to use your own create DDL statement and then just directly import the CSV.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: populate data from csv into oracle