Accessing SQL Server in Excel Macro
I am trying to read an SQL Server2k in VBA and it fails on code like
DIM conn as SQLConnection
I probably need to add a reference to a namespace of assembly, but I don't
know which one. Can anybocy help me?
Can you point me to a good tutorial about populating a worksheet from a
database.
thanks
walter
|