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_at_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 CET

This message: [ Message body ]
Next message: Steven Hill: "Debug/Tracing PL/SQL"
Previous message: Jens U. Veigel: "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"
Next in thread: LizRHW: "Re: 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