Connecting to SQL -Looking for best methods

[Richard Lawson]

Where is a good place to find information on connecting Excell to MS SQL? I
have been to MSDN and support.microsoft.com and found lots of articles but
they all talk around the details.

Is DAO the best approach? I am just looking for something which shows the
syntax for the connection and fetch.

I have lots of stuff that works with Northwind.mdb. I have done this with
VB6 and a Windows application, would it be the same?

Thanks,

Rich

 

[Bob Phillips]

The connection string would be similar, it would SQL Server not Access, and
the code would be largely the same. Same recordsets, same GetRows or looping
through the recordset.

See
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer
for the connection strings.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)