View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
walter1234 walter1234 is offline
external usenet poster
 
Posts: 1
Default 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