Re: Convert Excel Spreadsheet to SQL Script??
From: M. Armaghan Saqib <munshi8_at_yahoo.com>
Date: Tue, 18 Jan 2000 02:09:34 -0800
Message-ID: <01dfed54.dd0fad34_at_usw-ex0106-045.remarq.com>
If speed is the requirement, use my SQL Link for XL which uses native connectivity with Oracle using OO4O and upload your data from XL to Oracle
directly without converting to SQL Scripts
> Hi,
>
> I know this can be done but don't know how.
>
> How can I take a large Excel spreadsheet and convert it to use as a
SQL
> script?
>
> This would really speed up loading a bunch of Oracle Tables.
>
> I really appreciate any help someone can lend on this matter,
>
> Thanks,
>
> Jay Quinn
> jpquinn_at_home.com
Date: Tue, 18 Jan 2000 02:09:34 -0800
Message-ID: <01dfed54.dd0fad34_at_usw-ex0106-045.remarq.com>
If speed is the requirement, use my SQL Link for XL which uses native connectivity with Oracle using OO4O and upload your data from XL to Oracle
directly without converting to SQL Scripts
regards,
M. Armaghan Saqib
+--------------------------------------------------------------- | 1. SQL PlusPlus => Add power to SQL Plus command line | 2. SQL Link for XL => Integrate Oracle with XL| 3. Oracle CBT with sample GL Accounting System | Download free: http://www.geocities.com/armaghan/
+---------------------------------------------------------------Jay Quinn <jpquinn_at_home.com> wrote in message news:38836219.1CCF43AA_at_home.com...
> Hi,
>
> I know this can be done but don't know how.
>
> How can I take a large Excel spreadsheet and convert it to use as a
SQL
> script?
>
> This would really speed up loading a bunch of Oracle Tables.
>
> I really appreciate any help someone can lend on this matter,
>
> Thanks,
>
> Jay Quinn
> jpquinn_at_home.com
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * [Quoted] The fastest and easiest way to search and participate in Usenet - Free!