Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Using excel as a data source, but only getting 63 fields | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge | |||
Mailmerge wont see Added Excel Data source Columns | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |