LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
X_HOBBES
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Excel Data from another workbook or file tamato43 Excel Discussion (Misc queries) 1 February 28th 05 05:26 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 10th 05 09:20 PM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
How do I import data from a SECURED website into Excel? Jimmy Lam Excel Discussion (Misc queries) 0 November 27th 04 04:12 PM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 11:47 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"