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
ODBC and VBA 0
MS SQL Connection and Retreival 1
Quickest way to import data from mssql to Access table? 0
Mail Merge Word 2003, VB.NET 2008, CreateDataSource 1
ASP to Linked Access MSSQL2005 table (And ASP) 7
Cannot Connect to BCM Database 5
connect to sharepoint list with VBA 1

Top