We’ll start with the simpler of the two: embedding an Excel object.

Let’s take a look at the example workbook to see how it works.

For example, if you discovered that there was an error in the order quantity, you could change it.

The Total formula on the Input sheet would automatically recalculate, to show the revised amount.

Open the example workbook and a blank Microsoft Word document.

On the first sheet in the workbook, you’ll see a small table. As you can see, this gives you an embedded version of Excel within Microsoft Word.

With a very minimalistic user interface, users can focus on making changes to the table's data: The Edit Data feature allows users to edit a My SQL Table's data directly within the Excel spreadsheet the data was imported into, optionally the generated queries can be reviewed before pushing the changes back to the My SQL Server or users can configure to skip that review step and push changes as soon as they are typed in.Easy, quick and reliable; adding, deleting and updating data has never been friendlier for any type of user without any previous database experience.Or, type a record number in the yellow cell, to view that record number Instead of scrolling through all the records, you can select a specific record, based on its ID number.If you are an experienced developer you will appreciate the scalable, high-performance access ADO provides to a variety of data sources.For more information about ADO, visit the Data Access Technologies Web site on MSDN. The provider is a component that represents the data source and exposes information to your application in the form of rowsets.Even though tables have read-only status, however, applications can perform insertions and updates for Microsoft Excel tables.When an application performs a Save As command on Microsoft Excel data through the Microsoft Excel driver, the application should create a new table and insert the data to be saved into the new table. No other operations can be performed on the table until it is closed and reopened.