Results 1 to 2 of 2

Thread: mysql to excel

  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: mysql to excel

    Hi!

    I am trying to get some data from tables into Excel and I have tried numerous things with no luck. I can't use Select into OUTFILE at all because of Access Denied errors even though I have full permissions and I also tried different versions of the mysqldump command with no luck either. Can anyone help? Thanks a lot!!!

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: mysql to excel

    Originally posted by jmatchus
    Hi!

    I am trying to get some data from tables into Excel and I have tried numerous things with no luck. I can't use Select into OUTFILE at all because of Access Denied errors even though I have full permissions and I also tried different versions of the mysqldump command with no luck either. Can anyone help? Thanks a lot!!!
    Hi,

    this post has been here for so long, dont know if you have solved the prob.

    My suggestion is using myODBC availble on mysql.com. Once you can get connected with DSN thru myODBC, you can get mysql db data from excel by using MS query.

    I have use excel as end-user to connect to mysql db for data. its working great.

    Hope this help
    qha_vn

Posting Permissions

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