Getting Data From MS Access Database

Is this possible? I have MS Access DB on the file server and wanting to
query directly from ms excel. Hoping for your fast response.

Me

absolutely,you can make use of ADO to get data from Access DB via VBA code

OR you can click "data" ->"import externl data"->"database query"
so you can choose the data source and set up some query conditions.


"M P" <mark@textguru.ph> 写入消息新闻:uSifuSgLGHA.3424@TK2MSFTNGP12.phx.gbl...
> Is this possible? I have MS Access DB on the file server and wanting to
> query directly from ms excel. Hoping for your fast response.
>
> Me
>

And if you want to use parameters, check here

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk


"M P" <mark@textguru.ph> wrote in message
news:uSifuSgLGHA.3424@TK2MSFTNGP12.phx.gbl...
> Is this possible? I have MS Access DB on the file server and wanting to
> query directly from ms excel. Hoping for your fast response.
>
> Me
>

Hi M P

I have code examples here to try
http://www.rondebruin.nl/accessexcel.htm

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


"M P" <mark@textguru.ph> wrote in message news:uSifuSgLGHA.3424@TK2MSFTNGP12.phx.gbl...
> Is this possible? I have MS Access DB on the file server and wanting to query directly from ms excel. Hoping for your fast
> response.
>
> Me
>