From Autocad to Access

[tannermorrow]

Well I'm about to pull my hair out. I've searched through the limitles
depths of google and have yet to find an issue related to mine. Here'
the deal.

I have created a LISP file for Autocad that will extract the Ite
Number and Quantity of each individual block in an Autocad design. Th
LISP file then exports the contents of the drawing into a *.CSV file.

The issue I face now is how to create a Bill of Materials usin
Access.

I have a database set up in Access which contains each component's Ite
Number and Price of that item.

I want to be able to take the Items and their Quantity from the *.CS
file and I suppose somehow link it or cross reference it with th
Access Database so that it can give me a total cost breakdown of al
the items from the *.CSV file.

I'm not sure if there is a way to do that in Access or not. Any help a
all would be greatly appreciated! I'm desperate!

Thanks,
Tanner Morrow
Kidz Zone Playsystems, Inc

 

[Erik Oosterop]

From a big picture view, what you want should definitely be possible.

Your CSV file can be imported into a table in Access (you can automate this
with VBA). Subsequently, with a/some query, you should get to your cost
breakdown quite easily (assuming that there is identifying data that can be
used to cross referene).

 

[John Vinson]

Well I'm about to pull my hair out. I've searched through the limitless
depths of google and have yet to find an issue related to mine. Here's
the deal.

I have created a LISP file for Autocad that will extract the Item
Number and Quantity of each individual block in an Autocad design. The
LISP file then exports the contents of the drawing into a *.CSV file.

The issue I face now is how to create a Bill of Materials using
Access.

I have a database set up in Access which contains each component's Item
Number and Price of that item.

I want to be able to take the Items and their Quantity from the *.CSV
file and I suppose somehow link it or cross reference it with the
Access Database so that it can give me a total cost breakdown of all
the items from the *.CSV file.

I'm not sure if there is a way to do that in Access or not. Any help at
all would be greatly appreciated! I'm desperate!

This can be done in Access but - since a BOM is heirarchical rather
than linear, in that a component can be made of components, which are
made of components - you need to set up your tables carefully. There's
a sample BOM application at the Access Web:

http://www.mvps.org/access/modules/mdl0027.htm

Try searching google.com for "Access Bill of Materials" as well, there
are quite a few hits.