Is there a way to import excell 2007 into acad 2006?i can cut and paste, but it brings the table as an object.what i am trying to replicate is the way it used to work between excell 2003 and autocad 2004.  (the excell info came is as dtext cad text entities) I could more easily manipulate them because they were just cad text. And the text was formatted and aligned just like the spreadsheet. I really don't want a linked spreadsheet or an mtext version I have to explode and format manually.ThanksChris-

Can't do a Datalink in 2006 as that feature was introduced in 2008.You can either bring it in as an OLE object or use some third-party software to manipulate it.  See: http://www.dotsoft.com/xl2cad.htm


John Connor2011-06-22 18:27:26

thanks,I was hoping to find a workaround or a FREE LISP that would bring in the spread sheet as formatted simple text.Chris

Yes, everyone wants something for nothing.Take a look at this...Point Manager.http://lee-mac.com/ptmanager.html

Simple copy-paste (Paste as AutoCAD entities) should work. In newer AutoCAD versions, it brings the table as a TABLE object (AutoCAD table, not OLE table) but you can Explode it to simple entities.

thanks Johnis that LISP only for importing points?will it bring in text from excell as i have described.Hasta La Vista.....

Take a look at this discussion too re: Text from Excel into AutoCAD.http://forums.autodesk.com/t5/AutoCAD-2000-2000i-2002-Archive/Import-Excel-to-AutoCAD/td-p/939170