SQL
 

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....

SQL
 

Check out this link...

http://www.erlandsendata.no/english/...php?t=envbadac
--
HTH...

Jim Thomlinson


"Seba" wrote:

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....

SQL
 

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....