autocad e database

[123123]

I thank all in advance and I pray that I have not found in the discussions examined the solution sought.
the problem is this: from a dwg it is possible to automatically extract relevant data (such as areas enclosed by polylines) and write them in an access file in order to operate calculations and statistics?. of course it is also interesting the opposite direction (from access to autocad).
I hope someone answers me. greetings to all

 

[blubossa]

Hi.
I see it's your first message, it would be the case to introduce you before......

However what you ask is solved with the attributes to go to store the info and then extrapolate them when necessary in .xls or .mdb

I would have some other idea though it is perhaps better to wait for some gurus...

Hi.

 

[123123]

thanks for the answer

.... presentations aside... .
I meant "automatic extrapolar" and don't insert the data into the blocks and then export it to an external file.
a process similar to the creation of a dxf file, with the difference that while this generates a sequential file, it should load the data of the entities present in the drawing in the records of a database once defined the necessary fields.
in this regard I thought I would use, on a vb platform, a cycle "for" to withdraw from the dxf, for example, the coordinates of the initial and final points of the lines.

 

[blubossa]

In fact I didn't mean you have to feed the data type perimeter, area,...... but you should be able to catch them and store them directly in attributes. Obviously this technique precludes the creation of a block.

You should better explain what you want to do from where you go and where you want to get there.:biggrin:

 

[rpor66]

the _dataextraction command allows you to extract a whole set of entity properties and save them in a xls or csv file or as you prefer.
the reverse path is another story, when you will become master of autocad and lisp or vba maybe repropose the theme, now it is premature in my opinion.

Hi.

 

[123123]

Unfortunately the application must turn on 2004 and I think that command is not there (.... and then I always try to avoid the guided procedures).

in any case I managed to extract area and layers of closed polylines by writing a few lines in a simple vba program (using acdbpolyline with a for cycle).

However the data, if aligned, are stored in a txt, but I can't write directly in a mdb file.

even if I connect files with a vba adodc I can not migrate data in the mdb.

.... I think the road is still long... .

thanks to all for availability and good work.

I would be very grateful to you.

 

[ghirosoft]

Hi.
try downloading from here http://www.lucioghirardo.it/autocad.aspthe example

vba-access: example of connection with database.

 

[Giotto]

ti ringrazio.xd