We help IT Professionals succeed at work.

I am trying to use an access query as a data source in excel.

I am trying to use an access query as a data source in excel.
from the menu I choose data, access data from the data source and then my query name. it reads in the data I have currently entered. however, when I then enter more data in the query or table, the new data is not in the excel file.
any advice on what I am doing wrong? (i have office2007)
thanks
Comment
Watch Question

You need to Refresh the data in Excel, see below link:

http://office.microsoft.com/en-us/excel-help/refresh-connected-imported-data-HP010087045.aspx?CTT=5&origin=HA010099664

Hope this helps,
Daniel
PatrickData Analyst

Author

Commented:
thanks very much Daniel. i thought it would ge something simple, just wasn't finding it.
thanks
Pat

Explore More ContentExplore courses, solutions, and other research materials related to this topic.