How to Import Excel Into Your Database

Sdílet
Vložit
  • čas přidán 2. 07. 2024
  • Step by step demonstration of taking an excel (or CSV) file and creating a new Oracle table and then loading the data using Oracle SQL Developer.
    Yes, it's a Wizard. Yes, you can do it. Yes, there are a few places where you want to be careful.
  • Věda a technologie

Komentáře • 12

  • @user-cw1kj6xn6w
    @user-cw1kj6xn6w Před 3 lety +2

    Спасибо. То что нужно!👍👍

  • @na-ck9mn
    @na-ck9mn Před 6 lety

    Отлично! Ты молодец!

  • @davidespada01
    @davidespada01 Před 6 lety

    thanks , nice video really
    if you allow me how can i theme the worksheet like yours ?

    • @JeffSmiththat
      @JeffSmiththat  Před 6 lety +1

      David Espada sure thing www.thatjeffsmith.com/archive/2018/03/my-sql-developer-editor-setup-look-feel/

  • @binilarussel
    @binilarussel Před rokem

    hey thanks for the video. You used a csv file to import, not excel. Do you have a video on this specifically? Thanks

    • @JeffSmiththat
      @JeffSmiththat  Před rokem

      It's exactly the same. Just make sure your XLSX file doesn't have macros/pivot tables, etc - you want a workbook/worksheet with JUST the data in it.

    • @binilarussel
      @binilarussel Před rokem +1

      @@JeffSmiththat great! I’ll try that. Thanks for your reply.