Oracle SQL Developer - 无法导入数据 [英] Oracle SQL Developer - Can't import data

问题描述

我尝试使用SQL Developer 1.5.5将数据导入Oracle数据库。但它不支持MS Access文件。对于其中一个可用选项：xls，我将Access表导出为.xls文件，然后尝试使用SQL Developer导入数据。数据导入向导已打开。在第1步：数据预览中，向导上不显示任何内容。当我单击下一步到步骤2：选择列时，可用列面板中没有任何内容。谢谢你能分享如何进行数据导入。

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.

推荐答案

使用以下程序解决问题：

Problem solved by using the procedure below:

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.

这篇关于Oracle SQL Developer - 无法导入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！