Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refresh data from MS Access DB not picking up changes to criteria
Hi, I hope someone can help
I have a fairly basic spreadsheet which loads data from an MS Access query. It set up OK and if I change underlying data in the Access table, the refresh works OK and reflects these changes. However I have had to modify the Access query to exclude a number of records (by changing the criteria) and although the refresh still picks up changes to the underlying data (change of name for example) it still includes those records which should now be excluded. It is as if the query has not been modified. Has anyone any suggestions Ptero |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh Excel Sheet with Access Data Frequently | Excel Discussion (Misc queries) | |||
Error on Refresh Data Import from Access | Excel Discussion (Misc queries) | |||
Refresh Data if Access File has Password | Excel Programming | |||
Data Refresh Issues when linking Access queries to Excel | Excel Discussion (Misc queries) | |||
Ridirect & Refresh data from access database | Excel Discussion (Misc queries) |