Re: Excel to Oracle (to Temp Table)
Date: Tue, 21 Jan 2003 18:25:01 -0800
Message-ID: <#HGbs1bwCHA.456_at_TK2MSFTNGP09>
Here's an example I snatched from another message
SQL = "CREATE SEQUENCE SEQ_2 INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER" Set ThisCommand = New ADODB.Command
Set ThisCommand.ActiveConnection = OracleConn
ThisCommand.CommandType = adCmdText ThisCommand.CommandText = SQL ThisCommand.Execute , , adExecuteNoRecords ****************
This is for creating a trigger, but the same process should work with your create table SQL, provided the user has the required permissions.
Once the table is created just run a bunch of insert SQL statements, one for each record to be inserted.
Tim.
"Paul W Smith" <> wrote in message
news:b0jh1a$nl$1_at_knossos.btinternet.com...
> I have a client who wants a worksheet built which will be used to create a
> temporary table in an Oracle database. Is this a simple task?
>
> Can the 'upload' (table creation) be done from Excel or would the
procedure
> have to be run as an Import from Oracle?
>
> Any assistance would be gratefully received.
>
> PWS
>
>
Received on Wed Jan 22 2003 - 03:25:01 CET