Re: Excel to Orcale

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Fri, 06 Oct 2000 21:03:06 -0400
Message-ID: <39DE764A.18E6A9D0@Unforgetable.com>

Yogesh wrote:

> Dear Sir,
>
> I have the data already written in excel sheet. In following manner
>
> 200 43013221000002 100000001 00 000001 000003 G U
> 200 43013221000002 100000001 00 000001 000003 C U
> 00
>
> I have to dump it to oracle 7.x
>
> How can I achieve this . Please Help me in this regard

Write a VB or VBScript program that will open the spreadsheet with OLE, read each row in turn and insert it into the database using ADO and the OLE DB (MSDAORA) provider. Received on Fri Oct 06 2000 - 20:03:06 CDT