Link to home
Start Free TrialLog in
Avatar of Patrick
PatrickFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of danishani
danishani
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Patrick

ASKER

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