I am having an intermittent problem that I need help with….
I have linked an Excel 97 worksheet into Access 97, and then am running update queries to post data from tables linked from SQL servers into fields in the worksheet.
The queries run successfully, and the data shows up in the worksheet if you open it in table view.
HOWEVER… when I actually go into the Excel file, the data is not there.
In Access, I can drop the link and then re-link, and I still see the updated data in the table view. But still in Excel the updated cells appear to be empty.
This problem seems to happen only occasionally, with no discernable pattern.
This particular operation is something I perform fairly regularly, and the majority of the time it works perfectly, saving considerable data entry into Excel for the users.
A couple of my coworkers have also experienced this same problem.
We are running Office 97 SR-2 under Windows NT4 SP4.
I have linked an Excel 97 worksheet into Access 97, and then am running update queries to post data from tables linked from SQL servers into fields in the worksheet.
The queries run successfully, and the data shows up in the worksheet if you open it in table view.
HOWEVER… when I actually go into the Excel file, the data is not there.
In Access, I can drop the link and then re-link, and I still see the updated data in the table view. But still in Excel the updated cells appear to be empty.
This problem seems to happen only occasionally, with no discernable pattern.
This particular operation is something I perform fairly regularly, and the majority of the time it works perfectly, saving considerable data entry into Excel for the users.
A couple of my coworkers have also experienced this same problem.
We are running Office 97 SR-2 under Windows NT4 SP4.
