VBA to login to Teradata and bring table back to Excel

[wcassell]

I'm trying to write some VBA code from Excel, to login to Teradata and bring back a table into the Excel worksheet. Does anyone have any code that does this or something similar, or does anyone have any pointers for where to start?

Thanks

 

[dnoeth]

When you install the demo, there's an example at
Programs -> "Teradata for Microsoft Wndows Demo" -> "Sample Applications" -> "Excel Sample Query"

Dieter

 

[wcassell]

Thanks for the info . . . I work for a fairly large business, and they didn't give us access to the Demo stuff when they installed our tools and drivers. I've requested a demo disk from Teradata for myself. If anyone has any code already working I'd love to see it to play around with.

Thanks again!

 

[dnoeth]

I could email you the excel demo file:
dnoeth@gmx.de

Dieter

 

[fsnyder]

Create and test a file DSN to access your teradata database. From excel, choose data-> get external data-> new database query and select the name of the DSN you just created. Follow the prompts to create and run a query. After you have that working, start recording an excel macro and repeat the process, generating the VBA code. Modify and add parameters to the code as needed.