VBA Query Vertica database and populate to excel

0 votes
I run a Vertica database query (using squirrel-sql tool). Is it feasible to complete this task with Excel and populate a worksheet? Does anyone have a suggestion about how to resolve this?

Nothing regarding this can be found online. I know the hostname, port name, user name, and location of the driver.
Sep 24 in Others by Kithuzzz
• 20,660 points
78 views

1 answer to this question.

0 votes

You can query Vertica directly from excel. I did it and it works, just download the ODBC driver, install the driver, setup DNS and follow to instructions.

For version 7. x, read here

Full documentation: Installing the Client Drivers and Tools on Windows

  1. Download Windows Client Drivers from here. Excel requires ODBC drivers.
  2. Install drivers(double click on exe file -> next -> next -> profit!!).
  3. Set up ODBC DNS, instructions are here
  4. Follow to instructions here
  5. profit!
answered Sep 25 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Language independent way to get "My Documents" folder in VBA Excel 2003

 Hello :)  This code may help you in your ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
84 views
0 votes
1 answer

datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
1,832 views
0 votes
0 answers

How is it possible for DynamoDB to support both Key-Value and Document database properties at the same time

As per DynamoDB's documentation, it supports both ...READ MORE

Apr 5 in Others by Kichu
• 19,040 points
195 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
449 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,201 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
68 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
201 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
81 views
0 votes
1 answer

Excel web query to login into a website

To be recognized by the web server ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
148 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP