PDA

View Full Version : Export data from a Table to EXCEL


brian.thomas
2006-10-31, 06:44 PM
How? When I try to export, it only shows up as a picture on the spreadsheet. I need to be able to manipulate the information. I would also like to know how to bring info from EXCEL into an autoCAD table.
Thanks in advance.
avdesign
2006-10-31, 07:18 PM
Which version of AutoCAD are you using?
brian.thomas
2006-10-31, 08:06 PM
I'm using 2006. I've created a table with fields that are linked to dimensions for BOM's and I just want to be able to export that information, with the same formulas(unless there is a different way to produce the same results), from several drawings, into Excel and be able to manipulate it and if needed, to be able to export those same tables from Excel back into AutoCAD to update the tables. I'm assuming I would need to export them separately, which is still a far cry better than what I am doing now.
Mike.Perry
2006-11-01, 06:16 AM
Hi "brian.thomas"

Please note I have *moved* this thread from the AutoCAD Fields (http://forums.augi.com/forumdisplay.php?f=53) forum to this one, as I feel this particular forum is a more appropriate place for such a topic.

Thanks, Mike

Forum Manager
Mike.Perry
2006-11-01, 06:24 AM
Hi

For starters, take a look at the following thread...

Export to excel

Have a good one, Mike
rkmcswain
2006-11-01, 10:56 AM
I'm using 2006. I've created a table with fields that are linked to dimensions for BOM's and I just want to be able to export that information, with the same formulas(unless there is a different way to produce the same results), from several drawings, into Excel and be able to manipulate it and if needed, to be able to export those same tables from Excel back into AutoCAD to update the tables. I'm assuming I would need to export them separately, which is still a far cry better than what I am doing now.

As far as I know, there is no way to do this using only AutoCAD+Excel. You can export an AutoCAD table to a CSV file and open it in Excel, but you will lose formulas, etc.

You might take a look at AutoCELL (http://www.dotsoft.com/autocell.htm) and/or contact the author to see if this tool (or another) can do this for you.
brian.thomas
2006-11-01, 12:51 PM
Thanks for the help guys.