Convert (insert) excel spreadsheet data to oracle data

[discusmania]

Hi,

Base on data in excel spread sheet, i want to have a button that can insert the data there into a table in oracle. Let assume that the excel column header are the same as fields in oracle table. Please help me to do it.

Thanks and regards,
RoN

 

[Genimuse]

Excel spreadsheets can be opened like a database via ADO. Open both, SELECT from Excel and INSERT into Oracle. For better resource management use GetRows to grab the data from Excel and then close it, and then make your Oracle inserts.