Question is like this, is to make an external import procedures the EXCLE imported into the data window, and then imported into the Oracle of the data after further processing, now is the EXCLE column is not fixed, is likely to guide EXCLE each column is a change, I just want to do a similar to the import of used data function, read some of EXCLE SHEET first, and then read a few columns in the SHEET, the column name displayed, match the column names in the database, in the case of SHEET name, corresponding to the name of the database table, this allows the user to choose, which for which columns, and then the matching data processed wrote in Oracle, want to master please help have a good solution, if can provide a similar source program, really appreciated, thank you in advance!!!!!!!!!!

CodePudding user response:

Key column is not fixed, you are in trouble


-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - character signature -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Recommend a lot of large commercial source download address:
http://ujx.cn/bbs/X_AdvCom_Vip.asp? UserID=1
-------------------------------------------

CodePudding user response:

Yes ah, this is not the same, is can't make it like the sort of similar functionality SQLSERVRE import, read EXCEL column names, let them choose and corresponding column in the database, and then the derivative according to, don't know if you have a good solution, is glad

CodePudding user response:

Top

CodePudding user response:

Ideas should be feasible, is quite trouble, read write after setting cycle

CodePudding user response:

Unknown LZ talking about