VSQL output to excel

Answers

• Options

  mosheg Vertica Employee Administrator

  June 2023

  From Vertica's vsql command-line tool, you cannot directly create an Excel file.
  However, you can generate CSV output from Vertica using vsql and then convert that CSV file to an Excel file.
  For example:

  vsql -F"," -Atc "Your Query;" > Your_file_name.csv
  

  You can also query Vertica from excel after setting up an ODBC DSN.

  For example,
  1. double click in windows on ODBC_WINDOWS64bit_Vertica-client-xyz.exe
  2. Open the ODBC Administrator
  (For example, Start > Control Panel > Administrative Tools > Data Sources (ODBC)) --> at system DSN add Vertica
  3. Open Excel and from the menu, select Data > Get External Data > From Other Sources > From Microsoft Query.

  1
• Options

  elinorpurcell

  July 2023 edited July 2023

  @mosheg said:
  From Vertica's vsql command-line tool, you cannot directly create an Excel file.
  However, you can generate CSV output from Vertica using vsql and then convert that CSV file to an Excel file.
  For example:

  vsql -F"," -Atc "Your Query;" > Your_file_name.csv
  

  You can also query Vertica from excel after setting up an ODBC DSN slope game.

  For example,
  1. double click in windows on ODBC_WINDOWS64bit_Vertica-client-xyz.exe
  2. Open the ODBC Administrator
  (For example, Start > Control Panel > Administrative Tools > Data Sources (ODBC)) --> at system DSN add Vertica
  3. Open Excel and from the menu, select Data > Get External Data > From Other Sources > From Microsoft Query.

  Thanks, I will check it and let you know.

  0