Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Excel macro to put a spreadsheet into an sql type INSERT INTO TABLE VALUES sc

Re: Excel macro to put a spreadsheet into an sql type INSERT INTO TABLE VALUES sc

From: Frederic Bouquet <fbouquet_at_cornut.fr>
Date: 1997/03/20
Message-ID: <205258750.21864468@cornut.fr>#1/1

Jens U. Veigel,jens_at_deutschware.com,CINet writes: <<
Was wondering if anyone has a macro or some script that would format a column delimited file such as an excel spreadsheet into a format so it transformes each row in the spreadsheet into this format. (you know adding the ' ' and commas for each record). like that.

INSERT INTO TABLE VALUES
('value-for-column1','value-for-column1','value-for column2','value-for-column3','','value-for-column4','value-for column5',''); etc.

Don't have access to Oracle loalder etc, need to pump a few hundred records into a table, an record at a time, don't want to format it manually :o)

Any suggestion would be appreciated.
>>

Try CI-Link, it will provide you the possibility to download your data directly in your Excel spreadsheet from your Oracle Database. Everythink is available for free from www.cornut.fr

HTH --->> On our site a SHAREWARE SQL Query Tool <<------- --->> & a middleware much faster than SQL*Net <<-------

Frederic BOUQUET             Client/Server & SQL RDBMS
email: fbouquet@cornut.fr       http://www.cornut.fr/
Received on Thu Mar 20 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US