use Excel to create SQL statement, for example, enter your data (i.e. A1 and B1) into Excel worksheet, use another column (D1 here) to create the SQL statement which refer to the A1 and B1, then AutoFill the D1 until D999, assumed you have 999 rows of data in A1 and B1.
A1 B1 C1 D1
ibm International Business Machine ="insert into table1 (id,name) values ('" & A1 & "','" & B1 & "';" |