The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Loading Excel file to Vertica( not in csv format)
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.
0
Comments
You will need to create csv files and then load them into Vertica.
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