#1
|
|||
|
|||
Problem linking to Excel with ODBC DSN
I started this off in the Mail Merge Forum, but I suspect it beliongs here - we'll see !
I am trying to create a mail merge document in Word but when I try and link it to an Excel workbook ODBC DSN comes up with the error message "The Data Connection Wizard cannot obtain a list of databases from the specified source". I had thought this was a Word issue, but I have found that the ODBC DSN method works perfectly well when trying to connect to Access databases. So I believe that it may be Excel that is preventing the link from being made. Does anyone have any idea what settings might need to be changed ? Trust Centre perhaps ? I will get another PC where this works and open Excel side-by-side and simply compare all the settings. I might be wrong so I would be grateful for any insights please. Thanks, Martin |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
linking yahho and outlook 2013 problem | ernieo | Outlook | 0 | 10-29-2022 06:02 AM |
Strange behavior of Excel file with ODBC query in MS Cloud SharePoint | ArviLaanemets | Excel | 0 | 02-13-2019 05:23 AM |
Problem linking Visio to Word | sparcraft73 | Visio | 1 | 11-27-2015 08:28 AM |
ODBC Excel Driver Login Failed | ArviL | Excel | 3 | 03-01-2013 03:00 AM |
DDE, OLE DB, or ODBC? | timorrill | Mail Merge | 0 | 01-21-2009 01:42 PM |