Oracle SQL Developer - Can't import data

Question

0.00/5 (No votes)

See more:

I tried to Import data into an Oracle DB using SQL Developer 1.5.5. But the it does not support MS Access file. For one of available options: xls, I exported an Access table as a .xls file, and then tried to 'Import Data' using the SQL Developer. The Data Import Wizard opened. In Step 1: data Preview, nothing displays on the wizard. When I clicked Next to Step 2: Choose Columns, nothing in the Available Columns panel. Thanks if you can share how to do the data import.

Posted 5-Mar-14 7:40am

Member 10454592

Add a Solution

Comments

Vedat Ozan Oner 5-Mar-14 14:47pm

have you seen this: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/sqldev_migration/msaccess/migrate_microsoft_access_otn.htm

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 10454592 · Accepted Answer · 2014-03-06T02:59:00

Problem solved by using the procedure below:

VB

Step One: Export MS Access table as .csv
1)  Within Access, open the database table you wish to export.
2)  Within the Access menu bar, click External Data.
3)  To save as a text file for importing back in Volusion, click Text File.
4)  To save as XML, select More, and from the drop-down menu, select XML.
5)  For either file type, enter a file name for your database and click OK.
6)  Click OK or Finish on any following pop-up window.
7)  Open the saved .txt file, and then save it as .csv.

Step Two: Import .csv into Oracle DB
1)  Right-click the DB Tables and then click Import Data.
2)  In Step 1 of the Data Import Wizard, check on Header.
3)  In Step 2, choose all (or needed) columns.
4)  In Step 3, enter table name.
5)  In Step 4, click Finish button.
6)  Refresh Tables and view the imported table.

Thanks for your to review this thread.