topic Re: Importing Attributes from Excel in AutoCAD Forum

Importing Attributes from Excel

Anonymous — Wed, 15 Feb 2017 09:29:58 GMT

Greetings All,

I have more than 100 drawings, where I need to make multiple changes in Title block information. Using EATTEXT, we can export the attribute information from multiple drawings to Excel. Is there some way by which we can import attribute values updated in Excel back to respective drawings?

Thanks.

Samir.

RE: Importing Attributes from Excel

Otto — Wed, 15 Feb 2017 15:23:06 GMT

Hello samir.joshi and welcome to the Autodesk community!

It looks like you are looking for information related to datalinking between AutoCAD and Excel. Community members with similar questions found the following article(s) useful:

DATALINK (Command)

To update data links, use the DATALINKUPDATE (Command)

To provide an interface to external database tables use:DBCONNECT (Command).

If this information was helpful, please consider marking it as an Accepted Solution by clicking on the "Accept as Solution" link, below. Taking a moment to do this will help others with similar questions find useful answers. Thank you!

Kudos (click on the link or the "thumbs-up!" icon), are also gratefully received! (Even a bot likes praise.)

If this answer missed the mark, please let us know so that other community members can lend a hand. Any additional details might help, too: consider including relevant screenshots, log files, error messages, or system specs.

Betreff: RE: Importing Attributes from Excel

cadwomen — Wed, 15 Feb 2017 15:31:47 GMT

my this one ..

look / search for

UpdateTitleblockV1-9.lsp

cu cw

Re: Importing Attributes from Excel

Edwin.Saez — Wed, 15 Feb 2017 15:40:45 GMT

You can do it in the following way:

use the command "ATTOUT", ask you where to save the .txt, then select the block and export the information with all the attributes in the .txt.
open the .txt with excel, and there you can edit the information. The block will have a "HANDLE", which is a unique identifier of the block (a code)
when you have done the changes, you save the file in the same format .txt, then from autocad use the command "ATTIN", you will ask for selections of the file you edited, and automatically update the block according to the changes you made in the txt .

Betreff: RE: Importing Attributes from Excel

Jonathan3891 — Wed, 15 Feb 2017 16:43:50 GMT

The one posted by @cadwomen was created by @Lee_Mac and is found here.

It may be useful to visit his page to see a demonstration of how it works instead of trying to fumble through it.

Re: Importing Attributes from Excel

john.vellek — Wed, 15 Feb 2017 20:25:54 GMT

Hi @Anonymous,

I see that you are visiting as a new member. Welcome to the Autodesk Community!

I haven't used the lisp routine mentioned in this thread but I know that ATTIN as mentioned by @Edwin.Saez works really well. I would try it on a sample set of files to see if does what you want. This will be a tedious task though regardless. If you try the LISP routine please add a post on how it worked for you.

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Importing Attributes from Excel

john.vellek — Thu, 16 Feb 2017 21:21:14 GMT

Hi @Anonymous,

I am checking back to see if my post or others helped you with your problem. Please add a post with how you decide to proceed and your results so other Community members may benefit.
Please hit the Accept as Solution button if a post or posts solves your issue or answers your question.