View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JimP JimP is offline
external usenet poster
 
Posts: 11
Default SQL Server Stored Procedure

I use DAO objects, not ADO. I also tried MSDN and didn't get very far.

wrote in message
...
Hi JimP,

How can you be unfamiliar with Excel programming but be pretty
familiar with VBA?

And how can you be pretty familiar with VBA if you don't know ADO?

And it occur to you to search the Web before asking your question?

All you need to do is create an ADODB connection, a command object,
and run execute.

What is there not to know?

On Mar 6, 12:16 pm, "JimP" wrote:
Is it possible to use a SQL Server stored procedure in an Excel query?

Where can I get documentation to get me started? I'm unfamiliar with Excel
programming, but pretty familiar with MS-Access, VBA and TSQL.