Link to home
Start Free TrialLog in
Avatar of samisyed
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
Avatar of patrickab
patrickab
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
As a follow-up:

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.
Avatar of RubenvdLinden
RubenvdLinden

Any updates on your problem?
Is it working now?