Linking to Access

A

adn4n

Hi i would like to create a query in Access based on some information i
a form, i know how to do this, but how would i link this to Excel.
So that when i click a hyperlink in Excel, Access would open up an
give my the query...any clues? thanks
 
C

curtis

You can create an external data range based on some
parameters that are stored in the Excel spreadsheet if the
query is not very long. Provide a little more information
like how many parameters are in the query and the Access
query itself.
 
O

onedaywhen

You need to use a data access tool. The popular choices for Excel are
MS Query (GUI tools) and ADO plus OLE DB (VBA code).
 
Top