Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2023, 01:33 PM
MartinGM MartinGM is offline Problem linking to Excel with ODBC DSN Windows 11 Problem linking to Excel with ODBC DSN Office 2021
Advanced Beginner
Problem linking to Excel with ODBC DSN
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-21-2023, 01:15 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Problem linking to Excel with ODBC DSN Windows 10 Problem linking to Excel with ODBC DSN Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

This seems to be solved in your other thread ? https://www.msofficeforums.com/mail-...ew-source.html
If so, please let us now so that our volunteers do not waste time unnecessarily and mark this thread as "solved" ( see "Thread tools"). Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 05-24-2023, 02:26 PM
MartinGM MartinGM is offline Problem linking to Excel with ODBC DSN Windows 11 Problem linking to Excel with ODBC DSN Office 2021
Advanced Beginner
Problem linking to Excel with ODBC DSN
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default

Didn't know I could do that.

I do now, and have done so.
Reply With Quote
Reply

Thread Tools
Display Modes


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 to Excel with ODBC DSN Problem linking Visio to Word sparcraft73 Visio 1 11-27-2015 08:28 AM
Problem linking to Excel with ODBC DSN 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft