MS SQL Express connection string

Hi I have an excel spreadsheet that populates a 'mysql' database and all worked fine, However I now have to use the same code to connect to a mssql express database and populate that and I just cannot figure out the connections string (I presume the rest will work OK when I get the connection string right). The mysql database was stored locally via XAMPP. And the code to connect was as follows...

Please Login or Register  to view this content.

I now have my database set up in MS SQL Express (Part of visual web developer 2010 express) and I just cannot get the connection string correct. I have tried so many string based on various forums I have read. The latest is below trying via oledb Does anybody know the correct way to connect from VBA (in excel)

Please Login or Register  to view this content.

Any help much appreciated

What error are you getting?

[DBNETLIB] [ConnectionOpen(Connect()).]SQL Server does not exist or access is denied

changed to

'.\SQLEXPRESS'

Error message is now 'login failed for user... username

Maybe I have the password wrong now (although I am sure I dont)

Are you using integrated authentication (windows) or sql server authentication - username and password?