ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors (https://www.excelbanter.com/excel-discussion-misc-queries/17737-excel-error-while-trying-import-data-access-database-msqry32-exe-has-generated-errors.html)

X_HOBBES

Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors
 
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



All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com