Have you investigated using Data - Get External Data - New Database Query?
You don't really specify in a lot of detail what you are trying to do. You
can also retrieve an ADODB recordset (based on an Select query) which I have
code for but if the first option will work then I recommend going with
that...
--
HTH...

Jim Thomlinson


"grahammal" wrote:


How can I use an access data base from within Excel.
I already have all the information that is in this database in a
seperate worksheet and search this when I need to do so. I believe that
the search
criteria and speed is far better if I could utilise an access database
but dont know how to do this from within excel. I would like to achieve
this with a bit of VB behind a commandbutton.
Have I asked too much in one question.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=510665