exhuser
asked on
Excel Modify ODBC Settings
Can someone suggest how can I configure Excel to use the existing ODBC data connection in control panel? Right now it is trying to use something that is configured in Excel and I need to modify the settings every time it connects.
You'll have to check Data » Existing Connections » Connections in this Workbook (or named similar) for the connection data used.
Their you go check this site Here
It gives you all the connection strings that you might require or use to connect various databases with excel..
Saurabh...
It gives you all the connection strings that you might require or use to connect various databases with excel..
Saurabh...
ASKER
In Data --> Existing Connections how can I import the ODBC connection from the Control Panel?
Go to-->data-->from other sources-->From Data connection wizard-->ODBC DSN
and in their it will list all your ODBC connection and click next and follow the steps further and you will be good..
Saurabh....
and in their it will list all your ODBC connection and click next and follow the steps further and you will be good..
Saurabh....
ASKER
This option is greyed out.
Which means your worksheet is protected..Unprotect your worksheet and you will see that option back..
ASKER
Even with this wizard, I don't see the system DSN that I've configured in Control Panel.
Any idea?
Any idea?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've requested that this question be deleted for the following reason:
Not enough information to confirm an answer.
Not enough information to confirm an answer.