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.