Skip to main content

Loading Excel file to Vertica( not in csv format)

  • May 30, 2014
  • 3 replies
  • 22 views
anvy_elizabeth
Is there any  method to load excel files into Vertica database without using third party ETL toosl?Is it possible with COPY command?We also need to Load data from  all the tabs of Excel sheet.

    3 replies

    AK_1
    • AK_1
    • New Participant
    • May 30, 2014
    I doubt it's possible without a third party ETL tools. But there are some open sourced. I would use Pentaho data integrator.
    Adrian_Oprea_1
    Forum|alt.badge.img+1
    • Adrian_Oprea_1
    • Participating Frequently
    • May 31, 2014
    PowerShell for this. Check this link for the solution  
     You will need to create csv files and then load them into Vertica.
    gabriel_orozco

    So Far, What I am using that works with old .XLS and new .XLSX files, able to filter tabs and export with the separator I prefer (Ascii Field Separator) is this project:

     

    https://github.com/dilshod/xlsx2csv

     

    it has almost no dependencies, and I have it working on production for months now with very different excel files arriving without issues.

     

    Hope that helps

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement