addie2011-03-18 21: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.

westmont2011-03-19 03:18:44
Use Concatenate