Code to call MS SQL Server 2000 SP

Hot Topic

export lots of Access stored queries
Trim$ function in VB
Problem with MS Updates on New Dell
BSM Scorecard Report Views
partly remove the code from VBComponents
Extract text within several tables in word document
Disable editing Excel cells
For Each & Variable Problem
VB6 XP Themes support. Solved! Source included...
MS Office document and image writer print driver

Microsoft ISV

getting web pages from VBA?
Using user form to create list of files to be open
What significant contribution has Microsoft made to the US Government?
Independent. Sure, but at any price?
has anyone done the tests at all?!
Inaccurate double variables in VBA!!!
VBA for Powerpoint
help me
Dialogsheets vs Userforms
Independant Awards / Approvals

Code to call MS SQL Server 2000 SP

Hi Champs

I am .net developer and working on pivot tables/excel right now.

I am in position right now that i need to write code to call MS SQL 2000 SP in VBA code.

Can u please send me code for this and also any good site for getting VBA code help.

Thanks,

Answer this question

Code to call MS SQL Server 2000 SP

  • karabo

    Hi,

    You need to use ADO to access stored procedures in SQL Server from VBA. If your used to working with ADO.NET then you should have no problems using ADO. Look at the ADODB.Command and ADODB.Connection objects, very straightforward.

    Sorry I have no code to demonstrate.



  • Code to call MS SQL Server 2000 SP
Answer this question