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!
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!