July 25, 2012 at 7:22 pm #156880
Is anyone using software, plugin or found another “seemless” way of linking data between MS Xcel and CAD? I am currently making a datalink in CAD to the Xcel data and creating a table with the data link, but it is not easy to modify in CAD and if changes are made to the table’s size or formatting in Xcel, the table in CAD goes corrupt. I have also done the “paste special” to link the table to CAD, but the same thing happens. I have searched through the CAD forums online, but thought I would try this forum, since l.a.’s deal with multi-platform schedules & sheet registers. In my dream world, I would have one sheet register in an xcel file that automatically updates the drawing index in our drawings (CAD) and specifications (Word). As it is now, a lot of time is wasted updating each index separately. Any thoughts?
SusanJuly 25, 2012 at 8:10 pm #156887
Susan, I would suspect by CAD you are referring to AutoCAD, and for that I would not be able to offer a helpful suggestion. If you are looking for a CAD application that provides this currently, I would suggest you take a look at Vectorworks Landmark. With ODBC functionality, it does have the ability to tie the data from Excel to the worksheets within Vectorworks. I believe this link may further explain how this process works. http://kbase.vectorworks.net/questions/967/ODBC+Compatibility+-+ExcelJuly 26, 2012 at 4:09 pm #156886
Thank you Eric – yes, I was referring to AutoCAD. We do not use Vectorworks in our office; however, we have been considering it. Thanks for the recommendation.July 26, 2012 at 4:43 pm #156885
Dennis J. Jarrard, PLA, CLARBParticipant
I have created Schedules in Xcel and have successfully inserted them using “paste special” into Microstation files. I have never done this with Autocad.July 26, 2012 at 7:02 pm #156884
Yes, AutoCAD does this as well, but it is not always reliable – if the table is changed (i.e. rows or columns added or deleted) the linked table in AutoCAD does weird things.July 26, 2012 at 7:20 pm #156883
I don’t know about ‘seamless’, nor do I know how well the current versions are working, but I use an add-on called AutoXlsTable. In my version (2.53) it’s not completely automatic – you do have to click a tool and then the table to update it. But it’s fast, easy enough to use once you get the parameters down, and worked very well for the land use tables, plant schedules, drawing indexes, and other misc. charts we used it for.July 26, 2012 at 8:57 pm #156882
Thanks Chris – I’ll take a look at this. I know, seamless is probably asking a little much – but there has to be something that works better than my current method.July 27, 2012 at 3:58 pm #156881
Hi Henry – we do have LandFX in our office – I will have to see if it can do what we need – thanks for the recommendation!
You must be logged in to reply to this topic.