Hey guys,

I'm trying to connect an excel spreadsheet to a mysql database using odbc. The steps I used to do this in excel are Data -> import external data -> new database query. From here I enter the server name, mysql user name, password...etc. When clicking connect, I keep getting a "Access denied for user 'user@%' to database 'myDb' " error. The mysql database is on a remote server (I have admin privileges for it). Any suggestions would be appreciated.

I've never seen this error mean anything other what it says.

Are you sure your account has access to connect remotely?
make sure your case is correct on the db, user, password.