Linking to Access

  • Thread starter Thread starter adn4n
  • Start date Start date
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
 
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.
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Changing Database links? 3
Access query not showing as sources for pivot table 2
External data link to Access - no linked tables? 3
Link Excel To Access 3
Not all Access queries can be imported 1
Hyperlinks changed by Excel again! 5
importing/linking data from an Access 2003 Query to an Excel 2003 2

Back
Top