aspose file tools*
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
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
author & internet detective

Joined: May 26, 2003
Posts: 31073

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