ASE, SQL, OLE, ADE

ASE, SQL, OLE, ADE

Reply
*Perdaen, Alexis
Message 1 of 2 (46 Views)

Extracting attributes to Database, and keep a link between

46 Views, 1 Replies
03-29-2000 06:11 AM
I have a lot of plans (more than 500 !!!) which contains blocks with
attributes. I want to extract these attributes to an Access database, and
keep a relationship between Autocad and Access. So when I modify the
attributes, I want the database to change (this in both ways).
Actually, I extract the attributes into a TXT file, I take it in Excel, I
modify it, and save it into a CSV file, which I import in Autocad. I've made
a program in LISP which modify the attributes by reading the CSV file (using
handles of the blocks) and another that create a list of material next to
the drawing.
But there is too much operations between extracting attributes and importing
back in Autocad.

I use Autocad 2K, Access 97 and Excel 97. The best for me would be to have a
direct link with Access.

I wait for ideas, methods or programs examples...

You can mail me at :

alexis.perdaen@advalvas.be
or
assmom4d@win.be

In advance, thank you.

Ciao a tutti
*Fleming, Jon
Message 2 of 2 (46 Views)

Re: Extracting attributes to Database, and keep a link between

03-29-2000 03:45 PM in reply to: *Perdaen, Alexis
What you want certainly can be done. I don't know of any free programs to do
it.

If you are interested in programming in LISP, look at ADOLISP.ZIP and
DBL202.ZIP and ATTDB.ZIP from http://www.cadalog.com.

jrf
Member of the Autodesk Discussion Forum Moderator Program

In article , Alexis Perdaen wrote:
> I have a lot of plans (more than 500 !!!) which contains blocks with
> attributes. I want to extract these attributes to an Access database, and
> keep a relationship between Autocad and Access. So when I modify the
> attributes, I want the database to change (this in both ways).
> Actually, I extract the attributes into a TXT file, I take it in Excel, I
> modify it, and save it into a CSV file, which I import in Autocad. I've made
> a program in LISP which modify the attributes by reading the CSV file (using
> handles of the blocks) and another that create a list of material next to
> the drawing.
> But there is too much operations between extracting attributes and importing
> back in Autocad.
>
> I use Autocad 2K, Access 97 and Excel 97. The best for me would be to have a
> direct link with Access.
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.