updating mysql db with Excel2007

neit

Senior member
Dec 6, 2001
353
0
0
simple question, i've tried to google it but was having trouble forming the correct query.

My webhost uses mysql, i have connected to it via odbc driver, i have accessed the DB of interest in Excel 2007 and show it as a table.

Can I make a new row, enter values in the fields of interest (I have done up to this point), and then update the mysql db? whenever i press refresh it removes my changes; clearly I'm only refreshing to whats currently in the DB and therefore my changes are not committed.

Thanks!