Harish,
One way to generate connection strings is:
- Create a new text file somewhere suitable called "ConnTesrt.udl"
- Double click it.
- Make the required setting on the tabs, test the connection. OK.
-Open the file in a text editor to see the Connection string.

NickHK

"Harish" wrote in message
...
Hi all

I retrieve the data from database using folllwing Code and which works
fine.

With Selection.QueryTable
.Connection = "ODBC;DSN=XYZ;UID=abc;PWD=abc;SERVER=PQRS;"
.Refresh BackgroundQuery:=False
End With

But Now I want to use ADO retrieval method for data extraction. I am new
to
ADO technique, so if someone could help me to generate the connection
string
to my database through ADO would be great.

Your help would be greatly appreciated.

Kind Regards
Harish