-
Hi,
Can I directly load MS Excel files to Oracle DB without converting it to txt or csv files?
Thanks,
-
You cant load Excel files directly because they are binary files.
You should export them to a comma delimited/text file and then use the sqlldr utility to load/append data to the table.
regards,
Rotem.
-
-
There is plug-in product for Excel (SQL*XL) available that can do this.
URL: http://www.oraxcel.com
Sanjay
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|