Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 10th, 2006, 06:40 AM
Registered User
Join Date: Jan 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default VB Connection from Excel button

Can someone please assist me in creating a connection to an SQL Server 2000, within Microsoft Excel control button using VB code.

I have no idea how to establish a connection to a particular server that I need to retrieve data from.

If anyone can assist, that would be great?


Old January 10th, 2006, 09:11 AM
Authorized User
Join Date: Nov 2005
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts


~ ~ ~ There is no Right, There is no Wrong, KNOWLEDGE is Only the POWER ~ ~ ~

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a button with code into Excel hewstone999 Access VBA 0 March 18th, 2008 06:08 AM
Command button in excel sheet zone Excel VBA 2 August 13th, 2007 05:18 PM
connection string in excel sharcfinz SQL Language 2 May 7th, 2007 01:13 AM
how to use Excel VB to click a button which is!! tappenchris Excel VBA 0 November 30th, 2006 12:07 AM
Connection with Excel pliroforikarios VB.NET 2002/2003 Basics 1 November 22nd, 2005 09:55 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.