Loading excel file into database using SQL Loader
I need to load the data available in an excel into the database using the SQL Loader.
Since we get the excel from external 3rd party who are not ready to give us in a CSV format, I am forced to look into an option of changing the excel files into CSV format. Is there anyway I can load the files using SQL Loader? OR do you ahve any codes
loading csv using sql loader
with sql loader its quit simple :)
i m giving you a test control file for help
suppose ur table has two fields (field1,field2)
into table testCSV
fields terminated by ',' optionally enclosed by '"'