How to bookmark MS Access data

  • Thread starter Thread starter ML
  • Start date Start date
I'm not sure what you mean by bookmarking the Access data, but If you mean
pulling the same structured data from Access into Excel then:
create a query in Access to pull the data you like from your table/s
Open Excel
Click on Data >> Import External Data >> New database query
navigate to your dB/query (set up any needed sorting, etc)
Every time you add new data to your table/s, all you have to do is click
refresh data in Excel (Data menu or just click the execlamation mark/icon on
toolbar), and the new data will be imported from Access into Excel. But again
i'm not sure if that what you are after.

Thanks.
 

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

Back
Top