I saved it and it opened correctly the next time I needed it. Mine prompted for me to Select a Table (in my case an Excel Sheet within the spreadsheet) which you might not get.Īnd that's it.Navigate to the Excel file (or whatever kind of file) and click OPEN.Now you finally get a prompt that says "Find Data Source".I got "An operation cannot be completed because of database engine errors" Click OK.Click CANCEL on the Data Link Properties dialog box.Click OK on the 'Error has occurred ".is not a valid path"'.
Click YES to Opening this doc will run the following SQL command.Running Word 2016, I accidentally (thankfully!)ĭid the following steps to permanently link the file in its new location without having to do any of the remapping fields that everyone else suggests. I too found that changing the data source in that pop up window did not save. I moved all my files to a new computer, resulting in a new data path for the Excel file the Word mail merge doc is linking to.
setting the mail merge mainĭocument type to Normal Word Document in the mailings tab. Typically clicking Yes in the SQL dialog box should disconnect the old data source, but I would at least "make sure" by e.g. The problem, but in fact Word "reverts" to the previous source the next time you open. If you proceed from the dialog I mention, then choose the option to find the data source in the next or subsequent dialog, it does then appear that you have corrected That will happen if the previous data source has not been properly disconnected - e.g. If no, the wrong data source is "sticking". Does that file exist? Is it the one you expect? If yes, again, I would suspect the Excel file. When you see the SQL warning and click Yes, do you then see a dialog box which provides the workbook path/name.
For the default OLE DB connection type, the SQL message is the correct one - the SQL does not reference the workbook path or name - that comes from the file name or connection string which is not displayed in that dialog box.ģ. That may show that the file is/was at fault.Ģ. Do you have the same problem if you try to connect a completely new Word document to the data source? If so, probably something wrong with the Excel file - if you can reconstruct it, or even create a test file with the same sheet name and column names,
0 kommentar(er)
