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

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