I've upgraded Excel from 2007 to 2010 and now MS Query keeps crashing. I've read solutions about copying the MSQRY32.EXE file from Office 12 to the Office 14 directory but it doesn't seem to work - I get a message that it isn't installed.
The error states that Microsoft Query has encountered a problem and needs to close.
I'm trying to extract data from Sage Line 50 Professional 2012 into Excel. I don't really mind how I do it, I just need it to work, either via MS Query or another route if anybody has one.