| Author |
populate data from csv into oracle
|
Sam Venkata
Ranch Hand
Joined: Mar 06, 2006
Posts: 68
|
|
Hi,
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?
Thanks,
Samanth.
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26173
|
|
Samanth,
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
|
|
 |
|
|
subject: populate data from csv into oracle
|
|
|
0
