| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
