Connection between MSSQL from/to Excel

's Computer Specifications

Does anybody have a working example of connection to MSSQL via vba
(macros)?

Id like to be able to SELECT and UPDATE/INSERT to/from a MSSQL
database, locally on the computer.

Ill be very grateful for links, or any reply's.

Thanks!

Thøger Pørtner

's Computer Specifications

http://www.thescripts.com/forum/thread78660.html

some info on ADO
http://www.erlandsendata.no/english/...php?t=envbadac

this is mostly for access, but going to sql server should be similar.

--
Regards,
Tom Ogilvy

"(E-Mail Removed)" wrote:

> Does anybody have a working example of connection to MSSQL via vba
> (macros)?
>
> Id like to be able to SELECT and UPDATE/INSERT to/from a MSSQL
> database, locally on the computer.
>
> Ill be very grateful for links, or any reply's.
>
> Thanks!
>
> ThÃ¸ger PÃ¸rtner
>
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
what is the best way to manage about 2000 database connection / mssql+ asp.net	laziers@gmail.com	Microsoft ASP .NET	4	1st Dec 2007 08:45 PM
Problem with MsSQL Connection	=?Utf-8?B?QWlya29u?=	Microsoft C# .NET	3	12th Aug 2007 05:53 PM
Connection - MSSQL - HOST_ID	José Araujo	Microsoft Dot NET Framework	0	8th Mar 2006 11:06 PM
connection to msSQL	=?Utf-8?B?bmVYdXM=?=	Microsoft Frontpage	0	13th Sep 2005 01:52 PM
Resource of excel to connection mssql to get data	=?Utf-8?B?Sm9l?=	Microsoft Excel Programming	4	31st Jul 2004 07:59 PM