How to import a excel table data into the database table of associated

CodePudding user response:

Excel look like? Your watch is long what kind

CodePudding user response:

Will excel to CSV format

Import the use SQL Loader for much table

CodePudding user response:

You mean a EXCEL list different fields into different database table?
Simple method to return true not,
I generally use the ODBC importer in the PL/SQL,
Every time can only choose a database table, and then selected columns in EXCEL import,,,
Look behind the master how to solve

CodePudding user response:

Well, yes, that's all the fields in a excel form, to put them to the corresponding field data into related a few tables

CodePudding user response:

In the Java guide, such as in the end, as long as the excel all the fields of packing into an object, think how to guide all can,

CodePudding user response:

The question is too general,
Who know the rules of the excel data inside ah, you are going to split, or will excel split, or use other language tools,
Be implemented either using VBA in excel,

CodePudding user response:

SQLLDR multi-table import

CodePudding user response:

Is a sheet to the table? Or multiple sheet lead to multiple tables?
Is there are multiple tables in a sheet, will lead to many tables? Or a sheet is only one form, according to the conditions lead to multiple tables?

CodePudding user response:

Do not know the results of your excel, also don't know the results of your multiple tables, such a question hard to answer,
My advice:
1, use the ODBC in the PL/SQL importer import the temporary table
2, write a stored procedure (if the SQL level better, write directly complex update, insert, merage) to modify the data

CodePudding user response:

Temporary table will Excel data import entities directly, and then to the table, break up to you to specify each table