Michael, thanks for the advice. I can imagine exactly what you describe happening. Unfortunately the Excel sheets are formatted dependant on the data that is populated into them...

:D, very happy now. It seems to have been the fact that I used Nvarchar as a datatype for some of the fields. I changed those to varchar...

btw, I have other tables linked to the same msaccess db using the same ID and I see all the data.

Thanks for all your help but I can't solve the problem.

I have a Primary key on the ID field, and I have created the timestamp column with a type of...

Thanks folks, I will experiment with the datatypes for sure. Also I think I've tried almost every permutation of indexing I can think of. What's not clear to...

Thanks very much Michael, I was clearly making this harder than it needed to be. Works fine. I also take on your comments regarding MSAccess and convincing my...