Quote:
should
Set mvarConnection = CreateObject("ADODB.Connection")
be
Set myConnection = CreateObject("ADODB.Connection")
|
Yes it should - Sorry, I lifted the code from a class I use to do all of this and didn't edit it properly. - Asshopo - not having to set up a DSN would be most handy - I'm going to try that out, thanks!
Do you know if it works for any other databases, or only for MSSQL? Or I suppose, it should work as long as you've got an ODBC driver right?