connect an excel database to a dwg file

[m_cad]

Bye to all,
I just signed up to see if here I find an answer to a problem I have to solve. I have to connect an excel table to a 2011 autocad drawing by associating with each line of the table (which is a list in the end), an autocad object and make sure that updating the table also updates the dwg file, or at least I appear a warning in the dwg that tells me it is to update.
I make a concrete example: in the table I have a list of three objects a,b,c and in the dwg I have three circles that I must associate with a,b,c. adding a line in the excel file with an object d even in autocad I would like that object to appear or at least to appear an alert that alerts me of the fact that the table has an extra object (maybe saying also to me as it is hundreds of rows), vice versa eliminating a line I would like the dwg to disappear the associated object.
Thank you.

 

[Tristan]

xls file is a spreadsheet, not a database. . .
I don't know how you can do what you're asking.
Maybe with some .net or vba...

 

[calacc]

Bye to all,
I just signed up to see if here I find an answer to a problem I have to solve. I have to connect an excel table to a 2011 autocad drawing by associating with each line of the table (which is a list in the end), an autocad object and make sure that updating the table also updates the dwg file, or at least I appear a warning in the dwg that tells me it is to update.
I make a concrete example: in the table I have a list of three objects a,b,c and in the dwg I have three circles that I must associate with a,b,c. adding a line in the excel file with an object d even in autocad I would like that object to appear or at least to appear an alert that alerts me of the fact that the table has an extra object (maybe saying also to me as it is hundreds of rows), vice versa eliminating a line I would like the dwg to disappear the associated object.
Thank you.

something like this with 2011 I managed to do, it is a function that you find in the annotation card. type I managed to bring in autocad a table made in excel with the distinct base of a piece. it is possible (although a little bad according to me) to obtain the association excel -> autocad (and not vice versa ). but this is only related to the table is clear and certainly not to the ball or even to the pallinated component. Moreover it is autocad :36_1_10:

 

[Tristan]

something like this with 2011 I managed to do, it is a function that you find in the annotation card.

an account is to connect an autocad table to a xls file...
http://ctrl-alt-cad.blogspot.com/2010/04/collegamenti-dati-ms-excel.html...an account is to do what m_cad asks.

 

[m_cad]

Yes, I also had some doubt that something like that could be done. Thanks the same!