Combining AutoCAD Data Extraction Tables with Excel Tables

Ғылым және технология

The CAD Geek, Donnie Gladfelter, discusses how to create a dynamic AutoCAD table using block attributes, Extract Data tool, and an Excel spreadsheet. Using this procedure a comprehensive table including block attribute data, data extraction data, and Excel table data will be combined into a single AutoCAD table. Be sure to visit Donnie at thecadgeek.com for more tips and tricks just like this one.
----------
Subscribe to AutoCAD LT: thecadgeek.com/link/autocad-lt/
Subscribe to AutoCAD: thecadgeek.com/link/autocad/
For the latest AutoCAD Tips, Tricks, industry insights, and more visit thecadgeek.com

Пікірлер: 36

  • @paulobrito2009
    @paulobrito200912 жыл бұрын

    Thank you so much for the hints. I already created my own standards based upon your video and it´s still working very well.

  • @jthrilla84
    @jthrilla8412 жыл бұрын

    Thanks man! this is exactly what ive been looking for! I really didnt catch it all in a class I was taking last semester but this video explained it clearly!

  • @sreedharvp5925
    @sreedharvp59256 жыл бұрын

    very nice I have worked this many times but this video explained very clearly thanks

  • @tajammulhussainKhadir
    @tajammulhussainKhadir7 жыл бұрын

    wow this is what I was searching thank you so much..

  • @alirashad8260
    @alirashad826012 жыл бұрын

    hey man ,, thanks for helping keep uploading ur amazing videos

  • @argenism6
    @argenism64 жыл бұрын

    Very cool, thank you.

  • @danpaano
    @danpaano Жыл бұрын

    Thanks for this video. Can you share how to properly add a formula column to multiply the cost column from the external excel datalink with the count column. I keep getting an 'invalid data' error when I try it. Thanks in advance!

  • @sgs3131
    @sgs313113 жыл бұрын

    thank you very good demo

  • @mitsha01
    @mitsha0111 жыл бұрын

    I loved you video, explains data extraction very well... my question is can I add blocks to the data extraction table?... it will help me to show the block, the description of the block, the count, and extracted attributes of the block

  • @lindawang314
    @lindawang3143 жыл бұрын

    thank you so much!

  • @jonnasdrade
    @jonnasdrade5 жыл бұрын

    Nice Video. Question: how can I do If in the same example I need another extra column with a total price of all units?

  • @Mostafa20268
    @Mostafa2026811 жыл бұрын

    Thanks

  • @saiavinashrevanur8359
    @saiavinashrevanur83598 жыл бұрын

    After adding another multi-leader no.2, does the excel sheet also get updated?

  • @brandoneulberg1324
    @brandoneulberg13248 жыл бұрын

    Can you do this with parts and blocks as well?

  • @2002usama
    @2002usama8 жыл бұрын

    thanks

  • @hernandocimadevilla5839
    @hernandocimadevilla58398 жыл бұрын

    How can I avoid the count number if I have layers for some of the blocks? Thanks.

  • @wojtek_sanitarnik
    @wojtek_sanitarnik11 жыл бұрын

    What about double or triple multileader? Is it will be count as one?

  • @hernandocimadevilla5839
    @hernandocimadevilla58398 жыл бұрын

    Is there a way to use this but with also layers? I need to create the table easily but with layers because I need to show somethings sometimes and I just turn on/off the layers to see them or not in Autocad, but how can I link the autocad layers with Excel? Do you know how can do it? or Another way to create an Autocad Table with specific views depending of layers or options to only see in the table the items that I just need to see?

  • @shrinathingale
    @shrinathingale6 жыл бұрын

    Hey I need to plot excel file to cad as a drawing can we do it if yes then show me how.

  • @elvanovich
    @elvanovich13 жыл бұрын

    Great! But what happens with the excel sheet? Can you have a "count" column that reloads as well so it is linked both ways?

  • @arosionut
    @arosionut12 жыл бұрын

    Hello, did u know how connect xcel with autocad ?? I mean, when u click in autocad a text, to make link between autocad and excel data base ?

  • @shrinathingale
    @shrinathingale6 жыл бұрын

    Take a little complex design as example if yes

  • @58ahmed
    @58ahmed13 жыл бұрын

    ty vm :)

  • @moincad
    @moincad4 жыл бұрын

    How to link cad attribute tag with excel same tag no with having multiple sub items. For MTO. Supposed cad have 1 no id. But in excel 1 tag having multiple sub items i need to take out all mto with it

  • @inesmarques1892
    @inesmarques189210 жыл бұрын

    hey!I'm having problems with this...I create a new excel data link as you explain, but then in the next step when I browse for it I can't find it. Can you help?thanks a lot

  • @rdsamsterdam6430
    @rdsamsterdam64305 жыл бұрын

    This looks awsome , I tried it myself and all went well.....until I "link External Data".... I select the ID columns drawing & External ; after "Check Match" I get a error-message... "The data column in the external data does not contain unique values" Tried eveything but somehow I can't solve this. I bet it is something very simple. Any suggestions perhaps ? Thanks !

  • @reidjosh
    @reidjosh12 жыл бұрын

    Is there a way to not add the id if the count is 0?

  • @moincad
    @moincad4 жыл бұрын

    IF I HAVE MULTPLE BLOCKS OF DIFFRENT NAMES ? i tried but not working

  • @mukeshsahani6452
    @mukeshsahani64528 жыл бұрын

    can you do this vice-versa? ... I mean if i update in excel will it be update in drawing ???

  • @danstevens9245

    @danstevens9245

    7 жыл бұрын

    Yes, use the data link command to import your excel table.

  • @bizzoalbert
    @bizzoalbert5 жыл бұрын

    ta dando ruim!!!!!!

  • @1carlento
    @1carlento8 жыл бұрын

    long and complicated :(

Келесі