The way I do this is to create a DSN using the ODBC Control panel in Windows. I usually create a system DSN, then I use the name I give it as my name in the connection string.

This way the dsn can point at any database I want (including excel or access or MS SQL)

Cheers

Cheshire Cat