SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to import data from .cvs into oracle table

924924Mar 19 2012 — edited Mar 23 2012

Hi Everyone,

I am trying to import an excel file into an Oracle table. I am using the Data Import Wizard of Oracle SQL Developer 1.5.5 Build MAIN- 5969. When I get to the Data Preview dialog, (step 1 of 4) The Data Preview does not look right. For example: The data in column 1 contains some data from column 4. I import my data using a .csv file. When i open the .cvs file in excel the data looks fine. I tried using a different delimiter, as my data fields have commas which I want to preserve. But even that does not seem to work.
Any help would be greatly appreciated.

Thanks,
S

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2012

Added on Mar 19 2012

#sql-developer

12 comments

5,351 views