Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

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

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

From: LizRHW <lizrhw_at_aol.com>
Date: 1997/03/19
Message-ID: <19970319051500.AAA08497@ladder01.news.aol.com>#1/1

Yes you can do that; it is a bit tedious... create a cell with a formula

'insert into <your table> values ('''+ cell references etc+');'

I don't recall off hand what is the concatenation operator in Excel; and it is a little fussy about its quotes. You might also need to convert numbers to strings etc.

I have a spreadsheet at work that I did this a few weeks ago. I will try and email you a row or two tomorrow.

Dan Received on Wed Mar 19 1997 - 00:00:00 CST

This message: [ Message body ]
Next message: NNOOR: "Does ORACLE has any stupid restrictions like MS-SQL"
Previous message: Wesley Boisvert: "Re: Excel macro to put a spreadsheet into an sql type INSERT INTO TABLE VALUES script"
In reply to: Jens U. Veigel: "Excel macro to put a spreadsheet into an sql type INSERT INTO TABLE VALUES script"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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