Connection between MSSQL from/to Excel
 

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

Connection between MSSQL from/to Excel
 

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


" 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