Is there anything out there that will export all of a particular blocks attributes into either Excel or Access?
The attext command will let you select blocks interactively or by using "_previous" to retrieve a selection set made previously via the "select" command or (ssget) etc.
If I recall you lisp, so a very simple snip to illuminate --
(if
(setq ss
(ssget "x"
'(
(0 . "insert")
(2 . "MyBlockSpec")
(66 . 1)
)
)
)
(command
".attext"
"_objects"
ss
""
"_cdf"
"path/myTemplate.txt"
"path/myData.csv"
)
)
Appending umpteen csv files can be as easy as (dos command line) --
for %i in (*.csv) do type %i >> MyNewFile.csv
Or batch file --
for %%i in (*.csv) do type %%i >> MyNewFile.csv
As noted previously, Excel / Access have native ability to process delimited files.
Of course, all of this can be scripted, automated, programmed to varying degrees, using native commands as noted or doing a full scale assualt using the development language of your choice, extracting exactly what you want and the using ADO to create and then populate a database. It's not hard, I've done it, but it's more information than I care to type today so you will have to
do some research of your own.
But this --
Is there anything out there that will export all of a particular blocks attributes into either Excel or Access?
I have numerous blocks with the same name and they are full of attrinutes with specific room information.
I am using Autcad 2002.
Didn't suggest to me anything was needed beyond vanilla AutoCAD.