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 |
All times are GMT +1. The time now is 09:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com