Register now or log in to join your professional community.
You can find the answer in this link: https://w.dropbox.com/s/bsegkgk1xscwgxu/How%20to%20Link%20MS%20Excel%20or%20Access%20to%20AutoCAD.pdf
After inserting your Excel table, any updates made in the source Excel file will be updated in AutoCAD. By default however you will not be able to update data from AutoCAD, and have it update in the source Excel document. To modify a table value in AutoCAD, select a cell, right-click, and navigate down to “Locking”, and select “Unlock”.
-------------------------------------------------------------------------------------------------------------------1. Go to the Data tab in Excel and click the From Access button.
2. On the Select Data Source dialog, go to the location where the Access database is stored, select it, and click the Open button
3. On the Select Table dialog, choose a table from the database to import.
4. Accept the default options on the Import Data dialog, and click OK.
Excel and Access are now connected, and the data from the Northwind CustomersExtended table appears in Excel.
Now that Northwind can now easily view and analyze the information in its Access database, they want to make sure they are reviewing the latest information.There’s a couple ways they can refresh the data in their workbook.
Forced Refresh
To force a refresh, click the Refresh All button on the Data tab. This will instantly import the latest Access data into Excel.
Customized Refresh
Northwind can customize the refresh behavior for their workbook in the following ways:
1. Click the Connections button on the Data tab, and then click the Properties button on theWorkbook Connections dialog.
2. On the Connection Properties dialog, select the desired Refresh control options and click OK.
Nothing to add. Very good answer by specialties.