1. Home
  2. AutoCAD discussions
  3. Creating a Lisp to connect Excel data to Autocad

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.
Reply to
Dan S.
Loading thread data ...
I haven't done it with lisp, but I think
formatting link
has some info about (or similar to) that.
It's fairly simple with VBA, FWIW.
Reply to
TomD
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.
Reply to
Paul M
You can create script files directly from Excel, take a look at this procedure.
formatting link
Or if you were to consider third party software, the Block Place routine in ToolPac 7.0 from
formatting link
will connect directly to your spreadsheet (or database) and insert the blocks with attributes. Here is an example of the dialog
formatting link
Terry
Reply to
Terry W. Dotson
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.
Reply to
TomD
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....
Reply to
SW
I'd like to thank everyone for the help!!! Sincerly, Daniel s.
Reply to
Dan S.

Further Reading

  • How to connect to SQL server database in my Visual Lisp routine ?

  • Hi, Everyone,I'm programming in Visual Lisp. I need to get the information...

  • Excel to Autocad 2000

  • Hi all:I have a set of excel data that i need to translate into autocad dwg.Any...

  • Excel coordinates to AutoCAD

  • I am trying to extract some Excel spreadsheet coordinates (survey North/East...

  • How to export data to Excel

  • Does anyone know how I can export or link the data from a dimension in autocad...

  • Export data to Excel

  • have export to Excel , since a drawing of Solidworks the following ...

  • extract BOM data to Excel

  • Is it possible to extract BOM attributes from assy or part files to an Excel...

  • Exporting dims from Solidworks to excel

  • Hi,I need to export dimensions from Solidworks drawing to excel (or othereditor)...

  • How to configure the data link in Draw, to get data from Excel

  • Hello guys,I really appreciate it if you tell me how to get data from excel...

  • using DDE to get data from Excel in Data Link

  • Hello guys,Who can help me to solve my problem that I can not get data from...

  • Lisp?

  • Yardz a écrit :It looks like you need a specific application LISP or VBA, I...

  • A new way to display your Excel calculations

  • Hi, I would like to share with you a new handy Excel add-in that transforms for...

  • AutoCAD - Excel prob

  • Hello,I have an Excel chart on the autocad paper space but can´t do anything...

  • OS Data (NTF) to AutoCAD (DWG)

  • Does anybody have any ideas where I can get a batch converter for NTF...

  • AutoCAD 2002 drawing text to Excel 2000 spread sheet?

  • Anyone know of a way to import AutoCAD text into Excel? I've triedsome of...

  • Exchanging data with excel

  • Hi everybodyI'd have to calculate some element which comes from a complex...

  • Loading a lisp and when I restart al the loaded lisp are lost

  • Hello group I have a question, when I load a lisp and the next time I start...
  • « previous thread

  • Recommend a good plotter dealer in St Louis?

  • As you all may know.... my company is in market for a plotter. Budget is tight...
  • next thread »

PolyTech Forum website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.