Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

A lot of People is asking how to link Excel or Access to AutoCAD?

You can find the answer in this link: https://w.dropbox.com/s/bsegkgk1xscwgxu/How%20to%20Link%20MS%20Excel%20or%20Access%20to%20AutoCAD.pdf

user-image
Question added by Mohamed Abdul Monem Abdulah , Market leader , Zamil CoolCare
Date Posted: 2014/02/09
Mahmoud Anter Gaballah Alkotb
by Mahmoud Anter Gaballah Alkotb , BIM Modeler , Saudi Binladin Group

  1. Linking Excel and AutoCAD with Data Links 

    To set up Data Links:

    1. Launch the TABLE command.
    2. Click “From a data link“, and launch the “Data Link Manager” by clicking the button (illustrated).

    3. Click “Create a new Excel Data Link”

    4. Name the Data Link – something intuitive.

    5. Browse for your Excel Table

    6. The “New Excel Data Link” dialogue can be expanded by clicking the  button in the bottom right corner.
    7. Under “Cell Contents”, uncheck “Convert data types to text”, and check both“Retain Formulas” and “Allow writing to source file”. Checking those options will make it so your Excel formulas will be preserved, and that you will be able to make edits to the table in AutoCAD, and they be populated to the origional Excel file.
    8. Press the [Ok] button3 times to get out of the command, and insert your linked table.

    9. Assuming you checked the “Retain Formulas” option when setting up the Data Link, you’ll notice fields (text with a grey background) for any calculated value.

    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”.

    -------------------------------------------------------------------------------------------------------------------

2.about access to auto cad

you can link between access with excel then link with Autocad

Connecting Excel to an Access database

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.

Refresh data

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:

  • Enable background refresh (this option allows them to continue working in Excel while the refresh operation executes).
  • Refresh data after a specified time period (e.g. every30 minutes)
  • Refresh data when opening a workbook

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.

 

All connected!

Syed Shan Haider
by Syed Shan Haider , Senior Draftsman , Al Marwan General Contracting Company

Nothing to add. Very good answer by specialties. 

More Questions Like This