Is it possible to modify a Netezza table in Excel?

Asked By Douglas M Scott 20 points N/A Posted on - 05/15/2013

Hi guys.  I use a Netezza table for data warehousing and predictive analytics.  Is it possible to import and modify a Netezza table in Excel?  I use Microsoft Excel 2010.  Any help would be much appreciated.  Thanks in advance.

• Status: Open
• Question Views: 1231
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Holloway Hively 5 points N/A #145697

Is it possible to modify a Netezza table in Excel?

Hi Douglas,

Definitely you can possibly modify a Netezza table in Excel. You can use the following steps in accessing the Netezza table in an Excel spreadsheet.

1. First, download and install the Netezza OLE DB drivers.
2. From your Excel workbook, go to "Data" band and select "From Other Sources".  This will aid you in getting external data from the other sources aside from Access, Web, and Text.
3. Select "From Data Connection Wizard". The Data Connection Wizard window will be displayed.
4. Choose the "Netezza OLE DB Data Provider" from the selection window and click the "Next" button.
5. Insert the "IP" of the Netezza under the Data Source.
6. Input your Netezza account's "username" and "password" information then click "OK" button.

From there, you can now access and modify each and every table within your Netezza databases via Excel.

Hopefully I had helped you out with your Netezza – Excel concern.

About Holloway Hively

Questions
2

Answers
102

Best Answers
45

• Vote Up 0 Vote Down

• Posted on - 05/20/2013
• Question Category: MS Excel