Video není dostupné.
Omlouváme se.

Connect to MySQL from Excel (Complete Guide)

Sdílet
Vložit
  • čas přidán 19. 08. 2024

Komentáře • 23

  • @WTFIsThisGuyDoing233
    @WTFIsThisGuyDoing233 Před 6 měsíci +1

    Fantastic tutorial. Tried so many different bad ones before this

  • @cspopoff19
    @cspopoff19 Před 12 dny

    You da man, thanks homie.

  • @richardhay645
    @richardhay645 Před rokem +4

    Good.well explained.

  • @bntenza
    @bntenza Před rokem +1

    Excellent tutorial.

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

    Supper helpful. Really helped me out this morning. Many Thanks👌👌

  • @ekasaritiarawahyuni9094
    @ekasaritiarawahyuni9094 Před měsícem +1

    Can we edit the data via Excel once it's connected?

  • @KeithAul
    @KeithAul Před 6 měsíci +2

    how do we get the option under get data, from database? I don't see MySQL under this menu option

  • @ikke.gernoasje
    @ikke.gernoasje Před 4 měsíci +1

    Great tut, but what about 2-way connection? Or isn't this possible?

  • @sidindian1982
    @sidindian1982 Před rokem +1

    Excellent sir.. I will work out in this

  • @mariammusa478
    @mariammusa478 Před 3 dny

    Please how can i do this with sql server

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

    Hi, I don't have the option of 'MySQL ODBC 8.0 ANSI Driver' in the window, do you know the possible reason? Thanks! PS I have installed MySQL Community and created a database already.

    • @simonchevalier4419
      @simonchevalier4419 Před 9 měsíci +3

      when you start OBDC Data Source Admistrator, check that you opened the 64 bits version instead of 32 bits

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

      @@simonchevalier4419 thanks! I see it right now. However, I still need to figure out how to create a database so that there are values in the dropdown list of Database in ODBC Data Source window. May you giude me about that? Thanks!

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

      @@simonchevalier4419 thanks so much, I already saw that ANSI Driver. However I don't know how to add a databasr to the drop-down list of Database in the window. Could you please guide me how to do that? Or which keyword shall I search?

  • @alializadeh8195
    @alializadeh8195 Před rokem

    thanks

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

    Anyway to update as well

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

    How to connect to database from excel running on iOS?

  • @nolanmods7172
    @nolanmods7172 Před 10 měsíci +2

    I don't have the ANSI driver in my list...

    • @netharachamodya1049
      @netharachamodya1049 Před 10 měsíci +3

      same

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

      I downloaded the earlier version in this video. It had it built in.@@netharachamodya1049

    • @BrianRichi
      @BrianRichi Před 6 měsíci

      @@netharachamodya1049 Same

    • @donalodomhnaill
      @donalodomhnaill Před 4 měsíci +1

      To both of you, the reason you do not see ANSI driver on the list is because you are using version 8.3.0 instead of 8.0.36. Click the dropdown arrow to find that version

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

      @@donalodomhnaill That fixed it, thanks!