AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

Reply
Contributor
erin.dauk
Posts: 12
Registered: ‎11-03-2010
Message 1 of 6 (3,311 Views)

Import attributes using excel table?

3311 Views, 5 Replies
11-15-2010 03:14 PM

I understand that you can export attribute data to a spread sheet, but can you do the reverse?  Can you import attributes by using a spread sheet?  I have a table with well info (name, location, purpose, etc) that I would like to have tied to the blocks in the cadd file.  Is this possible??

Valued Mentor
tzzzzoddhepworth4253
Posts: 474
Registered: ‎05-10-2010
Message 2 of 6 (3,302 Views)

Re: Import attributes using excel table?

11-15-2010 03:52 PM in reply to: erin.dauk

yes it is possible - you can connect to the Excel table as an ODBC data source and then define a link template from the key in your Excel file (well number?) and use the linked table to label, thematic map, etc as if it is object data attached to the drawing elements or GIS "Feature" information.  Linking to Excel depends slightly on your operating system (different for Win7 64-bit versus a 32 bit OS).  post your system information if you need more specific information to point you along...

 

 

Cheers!

 

TdH

Valued Mentor
tzzzzoddhepworth4253
Posts: 474
Registered: ‎05-10-2010
Message 3 of 6 (3,300 Views)

Re: Import attributes using excel table?

11-15-2010 03:54 PM in reply to: tzzzzoddhepworth4253

My bad - I was thinking that this was the Map3D forum....  changes things drastically, as this is more of a Map3D function than it is "vanilla" AutoCAD.  Do you have access to Map3D or Civil3D?

*Expert Elite*
3wood
Posts: 1,154
Registered: ‎03-25-2009
Message 4 of 6 (3,232 Views)

Re: Import attributes using excel table?

11-17-2010 04:01 AM in reply to: erin.dauk

It is possible but first of all, there must be at least one attribute (A) assigned unique value for each block so the program can identify them individually.

You know there is a tool in Express Tools to export all attribute information, use it first to create a txt file.

Then work in Excel, merge the  data you want to import with that txt file, using (A) as the matching criteria.

Last step, go back to AutoCAD, there is another command in Express Tools to import attribute information from a txt file to the drawing. Use it to import revised txt file to update all block attribute values.

These 3-step method (Export to a txt file - Revise it in Excel - Import revised data) is also very useful to manage a drawing with complex block attibute information or split tasks to two persons: one persion in charge of the Excel data and another person in charge of drafting.

 

3wood

CAD KITS

Contributor
erin.dauk
Posts: 12
Registered: ‎11-03-2010
Message 5 of 6 (3,197 Views)

Re: Import attributes using excel table?

11-18-2010 07:01 AM in reply to: tzzzzoddhepworth4253

I do have civil 3D.  Thanks for your help!

Valued Mentor
tzzzzoddhepworth4253
Posts: 474
Registered: ‎05-10-2010
Message 6 of 6 (3,195 Views)

Re: Import attributes using excel table?

11-18-2010 07:28 AM in reply to: erin.dauk

from C3D, look at the "Map3D" side - either tool-based or task-based geospatial.  you can connect to the excel spreadsheet as an odbc data source and then "create joins" from excel to dwg objects.  check out the tutorials for map, or contact me off-line at  toddh_at_ctcivil_dot_com.  We may be able to do an online webinar where I'd be happy to show you the steps.

 

TdH

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.