Accessing SQL Server2k in Excel Macro

#1

How do I get a reference to SQL Server so that this code will compile?

Dim sqlCnn As New SqlConnection

Can you point me to a good tutorial on Writing macros in Excel that populate
cells from an SQL database?
Thanks

#2

http://support.microsoft.com/default...306125&sd=tech

Hope it helps

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

"walter1234" wrote:

Quote:

How do I get a reference to SQL Server so that this code will compile?

Dim sqlCnn As New SqlConnection

Can you point me to a good tutorial on Writing macros in Excel that populate
cells from an SQL database?
Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Accessing SQL Server2k in Excel Macro

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Accessing SQL Server2k in Excel Macro - 03-02-2009 , 08:58 AM

RE: Accessing SQL Server2k in Excel Macro - 03-02-2009 , 10:07 AM