Connection Excel vba to sql server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Connection Excel vba to sql server

Author

Topic

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2012-07-27 : 08:05:51

Hello there

does anyone know the syntax for connecting Excel VBA to a sql box that is not local, but on domain.

Im trying to execute a SP via excel

Regards

Rob

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-07-27 : 08:07:56

I assume you meant the connection string? Have a look at http://www.connectionstrings.com/
It is pretty comprehensive.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources