Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors

X

X_HOBBES

This is just an FYI for anyone who might encounter this problem (as I
just did)... =-)

::: SYMPTOM :::
In Excel, while trying to create a query into an Access database the
following error occurred:

MSQRY32.exe has generated errors and will be closed by Windows. You
will need to restart the program.

::: CAUSE :::
The Access database contains 'unfavorable' characters in the filename
(e.g. "MyAccessDatabase v1.0 (15-Mar-05).mdb" -- it doesn't like the
"." and is probably better off without the "(")

Rename the database to use a 'safe' file name (no spaces, or characters
that might confuse the system).

X_HOBBES
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error during importing data from Access to Excel 0
MSQRY32.exe error message 0
*.* has generated errors.. windows will close the application 1
HELP: Not able to generate query from excel for access 2007 1
Cannot Open Excel getting error: EXCEL.exe has generated errors .. 11
Import Access Data from 3 databases into 1 worksheet *ERROR* 0
Error message while trying to import Excel infomation to Outlook 0
Excel has generated error and will be closed by windows... 1

Top