Converting Access into Excel

[dwaynekelly]

I looking for an idiots way to query my Access database into an excel spreadsheet. Without the end user needing Access. Because I want it to work for multiple database files the simple query does not work. How can I do this?


VBIdiot

 

[JrClown]

Wouldn't an idiots way to query an Access database into an Active Server Page be easier??

I can help you if you'd like QUOTE OF THE DAY
Not to know if bad; not to wish to know is worse.
<%
Jr Clown
%>

 

[dwaynekelly]

True but, &quot;The customer is always right&quot;. I created a VB script in Excel that will run my query at the push of a button. But I want to be able to change the database to other files. How can I bring up a browser menu to select the database I want. I know you can do this it is just I was Trained in C/C+= etc. But I have little VB experience. Any help is appreciated.