Re: How to Import data from execl to Oracle Automatically

From: Linker IT Software <Please>
Date: Fri, 2 Dec 2005 16:17:51 +0100
Message-ID: <439065b6$0$2333$ba620dc5@text.nova.planet.nl>

You can use SQL*XL to load data directly from your sheet to the Oracle database. You can automate this by recording the actions once. You perhaps need to tweak the generated VBA code slightly to make it cater for a different number of rows to insert.

Find out about SQL*XL at www.oraxcel.com/projects/sqlxl

Alternatives are coding some VBA to save as csv and call SQL Loader.

Best regards,

Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com

>> I want to import excel sheet to Oracle database. But not manually. It
>> should be automatic. Is there any way...?
Received on Fri Dec 02 2005 - 09:17:51 CST