Excel Table to AutoCAD Table.

[Spenner]

Is it possible to insert a excel table into AutoCAD then convert it into an AutoCAD table format?

[Capt. Computer Crasher]

Is it possible to insert a excel table into AutoCAD then convert it into an AutoCAD table format?

Yes. Using AutoCAD 2006 or above.

1) Open the Excel file and Highlight all cells you want for the table.
2) Right-click and pick copy. Collapse Excel.
3) Open the AutoCAD drawing you want the table in.
4) At the Top AutoCAD menu under EDIT pick PASTE SPECIAL
5) At the paste special window make paste is mark and
pick AUTOCAD ENTITIES and hit OK
6) Pick an insert point.

Have your table style you want set to current when to insert the table or change it later.

[Spenner]

Beltin.

Thanks for this Capt Computer Crasher..

[anna.cummings]

When you start the table command, look in the upper right corner of the dialog box, under insert options pick "from data link" instead of "start from empty table". Then "create new data link" and follow the data link manager. It will give more options on how you want the data to stay in ACAD - just the text added to the table, a maintained link between the Excel file and the dwg, etc...

You can also extract data from the current dwg to Excel, like getting an inventory of your blocks. As more blocks are added to the dwg, then saved the Excel file will update.

[Capt. Computer Crasher]

When you start the table command, look in the upper right corner of the dialog box, under insert options pick "from data link" instead of "start from empty table". Then "create new data link" and follow the data link manager. It will give more options on how you want the data to stay in ACAD - just the text added to the table, a maintained link between the Excel file and the dwg, etc...

You can also extract data from the current dwg to Excel, like getting an inventory of your blocks. As more blocks are added to the dwg, then saved the Excel file will update.

the OP was operating in AutoCAD2007 which does not have the data link option.

[Spenner]

the OP was operating in AutoCAD2007 which does not have the data link option.

What versions does it work in?

[sajeer.ts]

HOW TO REMOVE THIS DATA LINK FILE FROM XREF IN AUTOCAD

[Capt. Computer Crasher]

HOW TO REMOVE THIS DATA LINK FILE FROM XREF IN AUTOCAD

Not sure what you are asking exactly. Are you wanting to remove a datalink from a drawing? or do you have a datalink in a drawing and that drawing is xrefed to a second drawing but you don't want the datalink to show in the xrefence list of second drawing?

if it is the first one:
1) First make sure the datalink is not being used. if it is being used, click on a cell in the table that is using the datalink. right-click then choose DATALINK >>detach datalink. this will detach the datalink from the table.
2) Second type DATALINK. This will display the Data Link Manager.
3) Highlight the datalink you wish to delete.
4) Right click and pick delete.
5)click "OK" to close the Data Link Manager

if it is the second one:
to my knowledge, there is not a way to do this without doing the steps above first and that may not be an option for you. These answers are based on AutoCAD200. I do not know if AutoCAD2009 or AutoCAD2010 can do it.

[The CADDinator]

Does anyone know why the 16th table locks up the program?

[Capt. Computer Crasher]

Does anyone know why the 16th table locks up the program?

Which version are you using and which service pack? also are you using copy/paste to add the datalinks or the data link option from the table command.
if you are using copy/paste try using the data-link option from the table command.