Excel and MySQL EP. 1 Connect excel to MySQL

Sdílet
Vložit
  • čas přidán 11. 09. 2024
  • Use Excel to connect and import data from MySQL database

Komentáře • 20

  • @Rabbani_World_Flock
    @Rabbani_World_Flock Před měsícem

    Jo cheez kahin mahi mili morning se vo yaha mili thanks bhai❤❤🎉🎉🎉

  • @user-iz3tx3jo3v
    @user-iz3tx3jo3v Před 11 měsíci +1

    it's the only one video which explain exactly what to do and shows that user name is root. thank you very much

  • @d8tascientist
    @d8tascientist Před rokem +1

    Thank you!!!

  • @sakansampattikorn
    @sakansampattikorn Před 7 měsíci +1

    Thank you ❤

  • @christianmastroianni4303
    @christianmastroianni4303 Před 2 měsíci

    Will this work if it is not a local host and I am using a server to run the website?

  • @MaherSabit
    @MaherSabit Před 5 měsíci

    i dont have a from odbc option, so instead i use data connection wizard and select odbc dsn, but it doesnt show the name, but when i tested the connection it worked beforehand

  • @tanakornnueangchomphu2790
    @tanakornnueangchomphu2790 Před 4 měsíci

    รบกวนสอบถามหน่อยครับ อยากแก้ไขข้อมูลที่แสดงบน excel แล้วไปอัพเดทใน MySQL ได้รึป่าวครับ

    • @tlextnoy5626
      @tlextnoy5626  Před 2 měsíci

      ได้ครับ ตาม ep3 เลยครับ czcams.com/video/nX358ef2l5U/video.html

  • @imamsobirin2344
    @imamsobirin2344 Před 8 měsíci

    how to do the opposite? sending data from excel to mysql? is it possible?

    • @tlextnoy5626
      @tlextnoy5626  Před 8 měsíci

      Yes, you can see in Ep.3
      czcams.com/video/nX358ef2l5U/video.html

  • @fanlovexcel
    @fanlovexcel Před 10 měsíci

    Hey guys, cause I am new to this area. Could someone guide me how shall I do that the dropdown list of Database would has list in there? Shall I create a database in MySQL Workbench which I already did, or create a database in Microsoft Access? Thanks so much!!!

    • @fanlovexcel
      @fanlovexcel Před 10 měsíci

      I mean the dropdown list of Database in ODBC Data Source window.

    • @tlextnoy5626
      @tlextnoy5626  Před 8 měsíci

      @@fanlovexcel the dropdown list of database will list all of databases you are already did under the server as example here of localhost.

    • @fanlovexcel
      @fanlovexcel Před 8 měsíci

      I already created a database by using MySQL workbench for localhost but I don't see it in the list. Do you know the possible reason?

    • @tlextnoy5626
      @tlextnoy5626  Před 8 měsíci

      Please make you already start your MySQL database, search "mySQL start" via google to see how to start MySQL@@fanlovexcel

  • @thihaui
    @thihaui Před rokem

    Help me
    Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (64-bit) and Application (32-bit)"

    • @tlextnoy5626
      @tlextnoy5626  Před rokem

      Hello, please make sure you download the driver 64 bit or 32 bit depend on your computer used. it's should be the same.

  • @sridharmallela
    @sridharmallela Před 7 měsíci

    I am getting this error,
    This application requirrs visual studio 2019 x86 Redistributable.

    • @tlextnoy5626
      @tlextnoy5626  Před 7 měsíci

      Then, you need to install it first .
      Referent info:
      dev.mysql.com/doc/connectors/en/connector-odbc-installation-binary-windows.html
      Before installing the Connector/ODBC drivers on Windows:
      - Make sure your Microsoft Data Access Components (MDAC) are up to date
      - Make sure the Visual C++ Redistributable for Visual Studio is installed
      - OpenSSL is a required dependency

    • @sridharmallela
      @sridharmallela Před 7 měsíci

      @@tlextnoy5626 thanks for the help