samisyed
asked on
Converting Excel file to Oracle using SQLLDR
How can I import excel file to Oracle using Sql Loader in Oracle 9i for Windows Operating System.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Any updates on your problem?
Is it working now?
Is it working now?
To convert an Excel file to a CSV file, just go to File/Save As and select the filetype as CSV - that's all that's needed. After that SqlLoader will accept the data as a string of data from the CSV file.