Migrate Data from MS Excel to SQLite and Back Again

Поділитися
Вставка
  • Опубліковано 20 січ 2025

КОМЕНТАРІ • 18

  • @jaydphenom
    @jaydphenom Рік тому +3

    The best type of videos are videos that answers real life questions a random guy from Nigeria who just encountered a need for migrating his data to sqlite might ask.

  • @mkaberli614
    @mkaberli614 6 місяців тому +1

    Thanks. It worked first time without a hitch.

  • @PillsLifestyleReviews
    @PillsLifestyleReviews Рік тому +1

    I don't understand a lot of it yet, but this was laterally my first question when I started learning SQL lite. Will definitely be trying this out in a month or two. THANK YOU!

  • @massimoriggio6297
    @massimoriggio6297 8 місяців тому +1

    Hello Sean, thanks for this wonderful class. Just a question: would this all work while the Excel file is closed?

  • @Chowchow_t
    @Chowchow_t 10 місяців тому +1

    Hi brother Sean! SQLite and Python is super useful for capturing data - i once used Python for UI (tkinter) for barcode scanners to capture data and connect to db using sqlite3 - one of my first actual project that got me to learn Python

    • @seanmackenziedataengineering
      @seanmackenziedataengineering  10 місяців тому

      Thanks for sharing! That's pretty cool work for Python 🛠

    • @Chowchow_t
      @Chowchow_t 10 місяців тому

      Oh yeah, I forgot to mention it was for daily inventory count - replaced paper and pen and the need to manual data entry. SQLite definitely useful!

  • @franklinmoura881
    @franklinmoura881 2 роки тому +1

    I loved it. Thanks so much for sharing your knowledge.

  • @belkmouf
    @belkmouf Рік тому +1

    Nice video Sean . I love it. Will it work for huge excel files of 200k of rows with 150 columns?

  • @LambertoSalucco
    @LambertoSalucco 2 роки тому +1

    Thank you, great example.