×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Populating Excel Table Into 1000 AutoCAD drawings

Populating Excel Table Into 1000 AutoCAD drawings

Populating Excel Table Into 1000 AutoCAD drawings

(OP)
I originally posted this in the Spreadsheet Forum. Somebody suggested me to move it here.

I am a Piping Designer and in many times I have to do the following repeated works:

We have 11x17 Piping ISO drawings in AutoCAD or MicroStation. Most of the time the drawing number is over 100, some time is more than 1000. In each drawing there is a shcedule imcorporated pipe line's specification data, including length, spec, insulation thickness, pressure etc.

Meanwhile, I also have to prepare exactly same pipe line's specification data in Excel. We call it LDT (Line Data Table).

We have to key in the same data twice (CAD and Excel). It takes us hundreds of hour to open 1000 drawings and change text in these drawings. After that the checkers also spend lots of time to check it. They open 1000 drawings and check it against Excel spreadsheet.

There are more headaches when the revisions coming in. In many time designer changes one place and forget to change another (CAD or Excel), which caused many inconsistencies in our work.

My question is:

Is there a good way, some add-ons to AutoCAD and MicroStation, for us to populate our LDT in Excel into 1000 drawings and maintain a link between CAD and Excel, so that for any revision we only need to change one place and the other will get updated.

RE: Populating Excel Table Into 1000 AutoCAD drawings

Sounds like you would need to develop a custom application to do this. I am not sure about MicroStation, but this would definately work with AutoCAD.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: Populating Excel Table Into 1000 AutoCAD drawings

if you used AutoCAD2k or newer, you can use "insertobject" and choose "link" model.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources