I have a project where I have to send data from an Excel spreadsheet to an Oracle database.
I have installed the latest Oracle client and the ODBC drivers. I have been searching for the right code to make the connection without effecting the TSN file. I also need to validate if I have made the connection and need to get the right code to send a range name of data to Oracle to update a table.
Any help would be appreciated.
The easiest way to complex approach is to convert the Excel file document to the .csv organization, and after that you can utilize the SQL loader making your own control record, or else you can make an outer table indicating your .csv record. Else you can parse your .csv record automatically and stack each line on your table utilizing ODBC, JDBC, et cetera.
Please write my thesis if it helped!