Record a query using MsQuery. This should give you all the connection
information you need.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Seba" wrote in message
...
Hello,

could enybody tell how to create SQL connection in Excel's macro editor ?

I've configured an ODBC connection but i don't know how to connect to
database....