Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    1

    Unanswered: mysql / odbc driver / excel

    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.

  2. #2
    Join Date
    Oct 2003
    Posts
    60
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •