Excel macro to put a spreadsheet into an sql type INSERT INTO TABLE VALUES script

Hi folks,

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.

Thanks

Jens

jens_at_deutschware.com Received on Tue Mar 18 1997 - 00:00:00 CET