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