ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Accessing SQL Server in Excel Macro (https://www.excelbanter.com/excel-programming/424912-accessing-sql-server-excel-macro.html)

walter1234

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