xls spreadsheet formulate some columns

來源: 2011-03-18 13:10:11 [舊帖] [給我悄悄話] 本文已被閱讀:

I have a xls spreadsheet, have like over 300 rows, and each row has around 10 columns.

 

I want to create 300 inserts based on each row, like insert into table values ('column1', '', 'column2' ,'column5......)

 

How to do that?


thank you in advance.