Reply
 
Thread Tools Display Modes
  #1   Report Post  
Rita
 
Posts: n/a
Default Error finding excel data source

Since a recent upgrade to Office 2003 (as well as a concurrent change to my
excel data document), when I open my main merge document, I get the following
messages:
1. Opening this doc wil run the following SQL command: SELECT from "active
Sites$". Data from your DB will be place in the doc. Do you want to
continue? Yes No. This part is fine. But upon selecting YES, this error
message:
2. This operation cannot be completed because of dialog or database engine
failures. Please try again later. After clicking OK ...
3. I have to "Find data source" ... ...
I have to do this for each and every merge document since this particular
excel spreadsheet is the data source for all my merges.

Thanks for your help.
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?Uml0YQ==?=,

The database engine failure message is often an indication that you need to
download and install a newer version of MDAC (data access components). See this
KB article

http://support.microsoft.com/default...b;en-us;322215

Since a recent upgrade to Office 2003 (as well as a concurrent change to my
excel data document), when I open my main merge document, I get the following
messages:
1. Opening this doc wil run the following SQL command: SELECT from "active
Sites$". Data from your DB will be place in the doc. Do you want to
continue? Yes No. This part is fine. But upon selecting YES, this error
message:
2. This operation cannot be completed because of dialog or database engine
failures. Please try again later. After clicking OK ...
3. I have to "Find data source" ... ...
I have to do this for each and every merge document since this particular
excel spreadsheet is the data source for all my merges.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Using excel as a data source, but only getting 63 fields Andrew Mailmerge 2 January 10th 05 03:02 AM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM
Mailmerge wont see Added Excel Data source Columns Thatdampwood Mailmerge 3 December 2nd 04 10:56 PM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM


All times are GMT +1. The time now is 11:33 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"