Shulou(Shulou.com)06/01 Report--

Today, I encountered a requirement to import a DBF file into Oracle library. I had been using the migration tool provided by the company before, but I don't know what happened. Today, I have been reporting errors such as DBF file cannot be accessed. After trying many times, I abandoned it in anger and found another way.

ODBC (Open Database Connectivity) is provided by Microsoft, specifically to solve the problem of data sharing between heterogeneous databases, which establishes a set of specifications and provides a set of standard APIs (application programming interfaces) for database access. These APIs leverage SQL for most of their tasks. ODBC itself also provides support for SQL language, users can directly send SQL statements to ODBC, an ODBC-based application to the database operation does not depend on any DBMS, do not directly deal with DBMS, all database operations by the corresponding DBMS ODBC driver to complete. That is, FoxPro, Access, or Oracle databases can be accessed using the ODBC API. Thus, the biggest advantage of ODBC is that it can handle all databases in a uniform way.

--The above content comes from Baidu

Without further ado, we first open the ODBC data source manager (32-bit), where because our PLSQL is 32-bit, it can only read 32-bit ODBC data sources.

We want to import DBF files, you need to be able to access DBF file drivers, this thing is Microsoft Visual FoxPro, is a long fox head software, installation methods are no longer described, please explore. After VF is installed, you can find the data source in the red box in the figure in ODBC data sources. Visual FoxPro Tables, not Visual FoxPro Database

In the configuration interface, we select the folder where the DBF file is located (not the DBF file, select the folder where the DBF is located).

After configuring the DBF data source, we log in to PLSQL with the Oracle database user we want to import and open the ODBC importer (Tool-ODBC Importer). Configure ODBC data source first, select the configured data source in Connection, and connect to the data source; select the table to import, and the data in the data source can be seen in the preview of the result below.

Switch the Tab page to "Data to Oracle" and select the user and table name of the table to be imported. The number of rows submitted for transaction can be adjusted appropriately according to the amount of data to be imported. Here, I adjust it to 1000 pieces of data submitted once. The import form is overwrite import (primary key duplicate data overwrite rather than skip). In the field column, correspond the fields of DBF and Oracle database. Pay attention to the selection of field type. If field type is not selected, the column data will not be imported.

Complete import, not only DBF, EXCEL, ACCESS, SQL Server, etc. can be imported through ODBC to achieve data migration.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.