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)