ASE, SQL, OLE, ADE

ASE, SQL, OLE, ADE

Reply
*Pocock, Keith
Message 1 of 2 (44 Views)

Connecting to a database

44 Views, 1 Replies
11-18-2002 12:44 AM
I have a drawing with about 1200 attributed blocks, each specifying plants
for a landscaping scheme.

At the moment I extract the attribute info and import it into an Excel
sheet, where I can sort and subtotal the quantities required. But if changes
are made in the drawing I have to redo the Excel sheet virtually from
scratch.

Should I be getting the attribute information directly linked to an Access
database? Can I do this with my existing plant name blocks? I have had a
look at the Help and I am not much the wiser... It all seems directed to
adding Database information to graphical objects, rather than vice-versa.

Any dumbed down explanation of the basic steps would be appreciated! I have
basic understanding of database concepts (I think).


Keith P.
*Fleming, Jon
Message 2 of 2 (44 Views)

Re: Connecting to a database

11-18-2002 09:09 PM in reply to: *Pocock, Keith
I don't know if you _should_ be writing directly to the database, but you
_can_. As you have seen, the built-in facilities in AutoCAD are oriented
towards information flowing from the database to the drawing and not
vice-versa.

There are third-party tools that will do the job, for example
<> and
<>. If these do not do what you want or
you don't want to spend any money, you can write your own application to do
it. You need to know some VBA or LISP.

If you are interested in writing your own application I can give you some more
pointers on that.

--
jrf
Member of the Autodesk Discussion Forum Moderator Program
Please do not email questions unless you wish to hire my services

In article , Keith
Pocock wrote:
> I have a drawing with about 1200 attributed blocks, each specifying plants
> for a landscaping scheme.
>
> At the moment I extract the attribute info and import it into an Excel
> sheet, where I can sort and subtotal the quantities required. But if changes
> are made in the drawing I have to redo the Excel sheet virtually from
> scratch.
>
> Should I be getting the attribute information directly linked to an Access
> database? Can I do this with my existing plant name blocks? I have had a
> look at the Help and I am not much the wiser... It all seems directed to
> adding Database information to graphical objects, rather than vice-versa.
>
> Any dumbed down explanation of the basic steps would be appreciated! I have
> basic understanding of database concepts (I think).
>
>
> Keith P.
>
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.