Excel inserts into database

Question

I have in excel some values(more than 200) in this format

PlayerId,Amount1,Amount2,Amount3

So how can i insert those values in some sql table with excel? How to write INSERT formula in Excel that will insert that values in my sql table(named TABLE1)

so i want to have something like INSERT INTO TABLE1(PlayerId,Amount1,Amount2,Amount3) VALUES(here put values from excel)

Possible duplicate of [Excel VBA: writing to mysql database](http://stackoverflow.com/questions/2821718/excel-vba-writing-to-mysql-database) — Carlo, Jan 19 '16 at 11:00

score 1 · Accepted Answer · answered Jan 19 '16 at 10:20

1

You can put this on another CELL and them drag it down to all the rows

=CONCATENATE("INSERT INTO TABLE1(PlayerId,Amount1,Amount2,Amount3)  values(",A1,",",B1,",",C1,",",D1,")")

answered Jan 19 '16 at 10:20

sagi

40,026
6
59
84

Excel inserts into database

1 Answers1