Connecting to SQL -Looking for best methods
 

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

Connecting to SQL -Looking for best methods
 

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....erForSQLServer
for the connection strings.

--
HTH

Bob

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

"Richard Lawson" wrote in message
...
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