See this example
http://www.rondebruin.nl/accessexcel.htm

I like the second example workbook where you can save the criteria

--
Regards Ron de Bruin
http://www.rondebruin.nl


"grahammal" wrote in message
...

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