Dear
I want convert my excel data into oracle 9i i have four column in excel sheet (1 NAME,2 SALARY,3 DATE,4 EMPLOYEE NUMBER) and number of record is 250 what i do convert excel data into oracle9i
Please help as soon as possible
Printable View
Dear
I want convert my excel data into oracle 9i i have four column in excel sheet (1 NAME,2 SALARY,3 DATE,4 EMPLOYEE NUMBER) and number of record is 250 what i do convert excel data into oracle9i
Please help as soon as possible
save it as a csv file, then use external tables or sql*loader to load the data in
If you need to write a procedure to do this for you (i.e. you need to do this load on a rgular basis), search Ask Tom for UTL_FILE.