how to insert data from excel to sql table code example
Example: sql insert from excel
Copy into Excel
=" INSERT INTO Table_Product (TBNID, PRODUCT , PRICE) values ('"&H2&"','"&I2&"','"&J2&"') ;"
Then change the Cell locations and drag down.
Copy into Excel
=" INSERT INTO Table_Product (TBNID, PRODUCT , PRICE) values ('"&H2&"','"&I2&"','"&J2&"') ;"
Then change the Cell locations and drag down.