Then I click the Send to Access button at the top of that sheet.
It runs a macro that opens an ADO connection to the database, inserts the Excel data, and closes the connection.
Sophanna, By changing 'ac Import' in that code to 'ac Link' (and providing a new, temporary table name) you will add the Excel sheet to your DB, and it will look like a table. So link the spreadsheet, write an update query (or write some VB code to accomplish same) and you're done. So to do this, after importing this spreadsheet to temporary table with code Do Cmd.
Learn more » My SQL for Excel now provides a way to edit a My SQL table's data directly within Excel using a new worksheet as a canvas to update existing data, insert new rows and delete existing ones in a very friendly and intuitive way.
Changes are pushed back to the My SQL Server as a transaction batch with the click of a button, or can be pushed as soon as they are done with no further clicks if users prefer it.
But at some point you'll probably bump up against the limits of Excel as a database manager and wish for the sort of flexibility that Microsoft Access provides.
Let's use an equipment inventory as an example (see Figure 1).
My SQL for Excel has been designed to be a simple and friendly tool for data analysts who want to harness the power of MS Excel to play with My SQL data without worrying about the technical details involved to reach the data they want, boosting productivity so they can focus on the data analysis and manipulation.