« previous next »
Pages: [1] |   Go Down

Author Topic: Retrieving data from an Access file  (Read 3025 times)

0 Members and 1 Guest are viewing this topic.

Amsterdammed

  • Guest
Retrieving data from an Access file
« on: November 10, 2005, 09:49:47 AM »

Hello everybody.

A time ago I learned here how to access data in vlisp from Excel. What would be the code for getting data from an MSAccess file?


Thanks in Advance

Bernd
Logged

Mark

  • Custom Title
  • Seagull
  • Posts: 28762
Re: Retrieving data from an Access file
« Reply #1 on: November 10, 2005, 10:03:11 AM »
The Visual LISP Developers Bible – 2003 Edition ( David Stein ) might have a hint or two.
Logged
TheSwamp.org  (serving the CAD community since 2003)

Amsterdammed

  • Guest
Re: Retrieving data from an Access file
« Reply #2 on: November 10, 2005, 05:49:54 PM »
Mark,
Sorry, Google didn't bring up the bible. Do you have any links or ideas where i can get that info?

TIA
Bernd
Logged

Bob Wahr

  • Guest
Re: Retrieving data from an Access file
« Reply #3 on: November 10, 2005, 06:15:22 PM »
It used to be www.dsxcad.com but is gone now.  If I remember correctly it was given freely with desire by him that anyone who wanted a copy could have one.  I believe that I have it at home.  He might have changed his mind though.
Logged

TR

  • Guest
Re: Retrieving data from an Access file
« Reply #4 on: November 10, 2005, 06:16:05 PM »
Try this
Logged

Bob Wahr

  • Guest
Re: Retrieving data from an Access file
« Reply #5 on: November 10, 2005, 06:23:08 PM »
big help


Not sure if it's still valid but you might try emailing him davidmstein at yahoo.com
Logged

Jeff_M

  • King Gator
  • Posts: 4096
  • C3D user & customizer
Re: Retrieving data from an Access file
« Reply #6 on: November 10, 2005, 06:33:02 PM »
Quote from: Bob Wahr on November 10, 2005, 06:15:22 PM
It used to be www.dsxcad.com but is gone now. If I remember correctly it was given freely with desire by him that anyone who wanted a copy could have one.
This is what I thought, too. I've placed it in the lilly pond for download.
You can also still see most of David Stein's site at archive.org
Logged

Jeff_M

  • King Gator
  • Posts: 4096
  • C3D user & customizer
Re: Retrieving data from an Access file
« Reply #7 on: November 10, 2005, 06:59:38 PM »
Now that the Developer Bible is taken care of I'll state that  there is nothing in it regarding Access.

However, here's a big help for Amsterdammed: Mr. Jon Fleming is the biggest expert in this field that I'm aware of. His WEB SITE has some excellent stuff for accessing Access databases. Go there and be amazed..... :-)
Logged

Bob Wahr

  • Guest
Re: Retrieving data from an Access file
« Reply #8 on: November 10, 2005, 07:07:11 PM »
Thanks for the link Jeff.  I always forget about archive.org.  It was fun poking around.  Followed a link on dsxcad to cad encoding then the link the the vbdesign forums...Ahh the good old days.  Fun little trip down memory lane.
Logged

Kerry

  • Mesozoic relic
  • Seagull
  • Posts: 11654
  • class keyThumper<T>:ILazy<T>
Re: Retrieving data from an Access file
« Reply #9 on: November 10, 2005, 07:50:40 PM »
I agree with Jeff's comment regarding Jon Fleming's site.
Give yourself some time to absorb it all.
« Last Edit: November 11, 2005, 07:55:39 AM by Kerry Brown »
Logged
kdub, kdub_nz in other timelines.
Perfection is not optional.
Everything will work just as you expect it to, unless your expectations are incorrect.
Discipline: None at all.

V-Man

  • Bull Frog
  • Posts: 343
  • I exist therefore I am! Finally Retired!
Re: Retrieving data from an Access file
« Reply #10 on: November 11, 2005, 07:34:09 AM »

Here, this will get you started.

Logged
AutoCAD 9 - 2023, AutoCADMap 2008 - 2010, Revit 2012 - 2022, Autocad Civil 3D 2023

MP

  • Seagull
  • Posts: 17750
  • Have thousands of dwgs to process? Contact me.
Re: Retrieving data from an Access file
« Reply #11 on: November 11, 2005, 08:01:10 AM »
I used to put all my DAO / ADO code in an ActiveX DLL and then call same from Visual LISP. Worked very well for years (and still does). But about a year ago I took a run at translating portions of the book "Access Database Design & Programming" to Visual LISP. To my surprise it didn't take much effort and even more surprising, execution was very fast. While translation may not appeal to you right at this moment, tuck the idea away in your pocket -- you learn very interesting things going that route. An aside, the noted book has proven very valuable to me, though admittedly, I'm a book hound (Collyer brothers anyone?).
Logged
Engineering Technologist • CAD Automation Practitioner
Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
cadanalyst@gmail.com • http://cadanalyst.slack.com • http://linkedin.com/in/cadanalyst

Amsterdammed

  • Guest
Re: Retrieving data from an Access file
« Reply #12 on: November 11, 2005, 02:40:41 PM »
Michael,

Well, it looks good to me. But right now i  just want to access some data from one file belonging to an other Application we work with. But I guess i got enough information on the links in threat.

Thanks, Bernd
Logged

MP

  • Seagull
  • Posts: 17750
  • Have thousands of dwgs to process? Contact me.
Re: Retrieving data from an Access file
« Reply #13 on: November 11, 2005, 03:17:57 PM »
Yep, to "tuck away" as noted -- some things are for a longer burn.
Logged
Engineering Technologist • CAD Automation Practitioner
Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
cadanalyst@gmail.com • http://cadanalyst.slack.com • http://linkedin.com/in/cadanalyst
Pages: [1] |   Go Up
« previous next »