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.
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.
•
Use Concatenate
-westmont-
♂
(79 bytes)
()
03/18/2011 postreply
19:18:44
WENXUECITY.COM does not represent or guarantee the truthfCCPA ulness, accuracy, or reliability of any of communications posted by other users.
Copyright ©1998-2026 wenxuecity.com All rights reserved. Privacy Statement & Terms of Use & User Privacy Protection Policy