ASE, SQL, OLE, ADE

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

Extracting attributes to Database, and keep a link between

41 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 (41 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.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community