• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

updating mysql db with Excel2007

neit

Senior member
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!
 
Back
Top