http://www.bygsoftware.com/examples/sql.html
Or you can get there from the "Excel with Access Databases" section o
page:
http://www.bygsoftware.com/examples/examples.htm

Okay, I found the old thread on Excel - Access and I downloaded thes
guys and they do work.

The problem is: When I try to use the code in my file it says that th
user-defined type "Database" is not defined. When I look in the hel
file I can't access the topics on the Databases Colletion etc.

I assume I need to install another feature of my Office but I woul
rather know which one than to install all 133 MBs worth. Also, th
examples create databases in an older format which is annoying. (I'
using office 2000 Pro)

Thank

--
TommySzalapsk
-----------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...fo&userid=2556
View this thread: http://www.excelforum.com/showthread.php?threadid=39072