Skip to Main Content

Database Software

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!

.csv data import via SQL developer

806245Mar 3 2011 — edited Mar 3 2011
I am trying to load an Access 2003 table into an Oracle 10g database via SQL developer. The Access file is located on another system and there is no ODBC connection between it and the SQL server.

What I have done so far is the following:

i) Export Access table as comma-delimited text file;
ii) Open text file and re-saved as .CSV;
iii) On SQL developer - created a table that matches the column structure in the original Access table, then right-clicked > Import Data > on Data Import Wizard I click Next...

after this, the wizard hangs on step 1, and does not allow me to move to the second step. It doesn't matter whether or not the SQL *Loader option is checked.

If anyone could offer some advice on the procedure I have applied above and possible sources of weakness, I'd be grateful to hear your thoughts. I'm relatively new to Oracel SQL and not very experienced with databases in general.

Thanks
This post has been answered by oradba on Mar 3 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2011
Added on Mar 3 2011
2 comments
285 views