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

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/