Search results

Thanks! I'll try posting it in other forums..The number of rows is only 8k and when excel tries to read data from access it collapses at 75 rows

Unfortunately still doesn't resolve the issue :( I checked the formats as well

Thank you...Though I've tried those options all of them crash the excel with the same error message "Microsoft excel has encountered an error and needs to shut down" pops up. However I'm able to do an export of the query. But I'm looking for a way to have a pivot that can auto refresh. Any...

Hi, I'm very new to access but somehow could figure out ways to get my output in access building queries with dlookup formula. However when I open up excel and try inserting a pivot table to get data from the access query, it gives me the error message that "Microsoft excel has encountered an...