Results 1 to 5 of 5

Thread: mysql to excel

  1. #1
    Join Date
    Jul 2012
    Posts
    3

    Unanswered: mysql to excel

    hello..

    i'm beginner in using mysql...anybody help me how to connect the data from mysql to excel..

    i need your help....
    thank you..

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you probably need to connect using ODBC. set up an ODBC datasource, then connect in Excel
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2012
    Posts
    3
    i download the connector..
    but the step by step procedures..i didnt make it..
    because i didnt understand some procedures...like the picture that i attached

    can you please explain to me farther these things..

    the "DATA SOURCE NAME" & "DESCRIPTION" - am i giving/naming it?
    the "TCP/IP SERVER" it is the ip address of the server of mysql?
    the "DATABASE" it is the name of the database that i wanted to connect to excel?

    up to that procedure i stop..

    i hope you understand what am i saying..
    Attached Thumbnails Attached Thumbnails 1.jpg  

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try the help button, or try whoever owns / maintains the datasource you want to connect to

    but:-
    DSN is the name you want to appear
    description tells a bit more about the DSN

    tcp/ip is the name of the server the port should be 3306
    username is the username given to this usage for that db
    likewise password
    dataabse is the name of the db you want to connect to (i'd expect that to be filled in for you once the connection to the server is authenticated
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jul 2012
    Posts
    3
    thanks to the reply..

    yah..i already know.....

    thanks again...


Posting Permissions

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