I have a button that runs a query that dumps the data in my tables to an Excel file. When the data in the tables is modified and the query is run again, the Excel file does not reflect the changes made in the table. I thought this would occur in real time, i.e., change the data in Access and run the query to output to Excel and the changes made in Access would be reflected in the Excel output. However the Excel file is remaining the same regardless to changes in the data. Would be grateful if anyone might help me understand why.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data dump to Excel file not updating in realtime
- Thread starter elviajero
- Start date
Similar threads
- Question
- Locked
- Question
- Locked
- Question
