Answer to Question #211458 in Databases | SQL | Oracle | MS Access for keerthana

Question

how can we load data from excel file into table through sql loader tool

Answer 1

1.Step 1: Mouse-right click – Import Data.

2.Step 2: Select your input (XLSX) file and verify the data.

3.Step 3: Create a script or import automatically.

4.Step 4: Select the Excel Columns to be Imported