Connecting to SQL Server table

firazad1@yahoo.com

Guest

Posts: n/a

7th Mar 2007

I have an Excel worksheet which has column with a number of rows
representing accounts. I want to write a VBA macro in where I need to
go get the matching value in SQL Server table using the value in the
excel workbook and write to next column.

Pls. help me code this.

Thanks

« RefreshAll in a shared workbook | Data Validation - Multiple selection. »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote	aboutjav.com@gmail.com	Microsoft ASP .NET	0	3rd May 2008 01:43 PM
when i am connecting vpn to client my system will not connecting server	koteshsvv@gmail.com	Microsoft Windows 2000 RAS Routing	1	24th Mar 2007 02:11 PM
Re: Connecting a SQL table to an exchange server	michael.bollhoefer@tybrin.com	Microsoft VB .NET	1	24th Aug 2005 05:14 PM
Vb.net ADO connecting SQL Server and Paradox table to create a query.	Roger	Microsoft ADO .NET	0	31st Mar 2005 03:22 PM
create table using access 2000 connecting to SQL Server 2000	=?Utf-8?B?Q2hyaXM=?=	Microsoft Access Queries	0	11th Jun 2004 06:41 PM