Creating a Lisp to connect Excel data to Autocad

Hello Everyone, I was wondering where i might find some information on connecting an Excel Database to Autocad, so that i may use Data typed into the
database as Coordinates placed into autocad. I work at a Geotechnical firm and we deal alot with placing block symbols into certain points in autocad. Any help will be very much appriciated.
Thanks, Dan s.
Add pictures here
✖
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Dan S. wrote:

I haven't done it with lisp, but I think www.acadx.com has some info about (or similar to) that.
It's fairly simple with VBA, FWIW.
Add pictures here
✖
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Tried it,,,, really slow site. I've got a dsl connection and still waited.... Someone needs to mention to this person to reduce the resolution of the graphics....

Add pictures here
✖
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
SW wrote:

Thought it was just my crappy connection. The site is worth the wait, though. There is some really good info, there.
I think the page owner(s) are regulars in Adesk's VBA NG.
Add pictures here
✖
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Dan, Have you looked into dbConnect. In AutoCad 2000 and 2002 it is under the tools menu. It works with Excel and Access. You can attach data from your spread sheet to blocks. It can be a little buggy but it is worth checking out.
Paul M.

Add pictures here
✖
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
"Dan S." wrote:

You can create script files directly from Excel, take a look at this procedure.
http://www.dotsoft.com/procedures.htm#ExcelScripting
Or if you were to consider third party software, the Block Place routine in ToolPac 7.0 from http://www.dotsoft.com will connect directly to your spreadsheet (or database) and insert the blocks with attributes. Here is an example of the dialog
http://www.dotsoft.com/images/blkplace.gif .
Terry
Add pictures here
✖
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
I'd like to thank everyone for the help!!! Sincerly, Daniel s.
Add pictures here
✖
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Site Timeline

Related Threads

Polytechforum.com is a website by engineers for engineers. It is not affiliated with any of manufacturers or vendors discussed here. All logos and trade names are the property of their respective owners.