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??
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...
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?
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.
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.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.