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 script

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

From: Wesley Boisvert <boisvert.wes_at_ic.gc.ca>
Date: 1997/03/18
Message-ID: <01bc33f4$4fe5fa80$110fbba1@boisvew>#1/1

Hi,

        I have a friend of mine who just had a requirement to do just that for data conversion purposes. He used 2 programs, MS Excel and Centura's Database Explorer and just copy and paste the Excel data right into the database tables (obviously the columns have to match 1 for 1 from Excel to the DB table) and it worked fine. He copied at most 10 000 rows at a time.

-- 
Wesley Boisvert
boisvert.wes_at_ic.gc.ca
Received on Tue Mar 18 1997 - 00:00:00 CST

Original text of this message

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