Connection between MSSQL from/to Excel

T

thoegerp

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report not printing all groups 1
Prob: Connecting to MSSQL using windows authentication 7
Permission to access dB problem in SQL Server 2005 Express from inside VS2005 2
Access and MSSQL 1
How to generate "plain" SQL with OleDb or Odbc providers, in db in 1
Cannot Connect to BCM Database 6
Problem with MSSQL 2005 and my app. 3
ODBC Connect wizard does not open 1

Top