将excel表格容添加到oracle数据库的方法.doc

将excel表格内容添加到oracle11g数据库的方法 本文只是简单的介绍一种常用的方法。 将excel表格另存为“*.csv”格式或“*.txt”格式，如下图所示。 登录oracle的管理界面，如下图所示。 选择“数据移动”选项，并选择“从用户文件加载数据”，如下图所示。 加载数据之前，要选择控制文件，一般选择默认的“自动生成控制文件”既可，注意主机身份证明中的用户名和密码一般是个人计算机的用户名和密码，这应该是与数据库安装时的配置有关，如下图所示。 选择要上传的文件，即cvs文件或txt文件，如下图所示。 选择数据表名，如果数据库中还没有此表，需要先创建该表，如下图所示。 查看加载结果 先输入“sql语句”，再点击“执行” reform results, economy, and political system, and culture system, and social system, and discipline check system, and party of construction system reform solid advance, tax, and financial, and price, and administrative approval, and State-owned enterprises, and ecological civilization, important field and key link reform made major progress, market in resources configuration in the of decisive role significantly enhanced, Unprecedented burst of momentum and vitality of economic and social development. XI General Secretarys speech in this regard include the reform only when there is no complete, the decisions of the CPC Central Committee on some major problems in deepening reform notes on the 18 session of ideas into the partys spirit of the reforms more difficult to move forward, the increasing use of the Socialist system with Chinese characteristics such as the ability to run the country. 4. with regard to promoting sustained and healthy economic development. Face complex changeable of international situation and difficult heavy of domestic reform development stable task, XI General Secretary made China economic development into new normal of science judge, proposed innovation, and coordination, and green, and open, and shared five big development concept, implementation macro policy to stability, and industry policy to associate, and micro policy to live, and reform policy to real, and social policy to backing five big pillar sex policy, vigorously advance supply side structural reform, new concept, achieved has 2013 to 2015 during, Domestic production total annual growth 7.3%, obviously fast Yu earlier world economi