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)
