All Forums Database
Nadejda 5 posts Joined 04/13
22 Jan 2014
Connect VBA to Teradata

Hello,
I need your Help to connect VBA application to Teradata database.
Wich provider can i use? and how can i use it?
Thank U
 
Nadejda
 

Raja_KT 1246 posts Joined 07/09
25 Jan 2014

Hi,
In excel, there are some settings where you can configure and you can write query too . But my experience for large voulume of data it hangs. 
Can you try with these examples given:
http://teradata.uark.edu/research/smith/td_app_example.html
I always have hiccups in Microsoft products programming :). In unix , c,c++, java etc it is more straightforward, with less add-ons and configurations.
Cheers,
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

NetFx 346 posts Joined 09/06
25 Jan 2014

If you must use VBA, then search for "VBA ADO ODBC and MSDASQL". You will find lots of examples.
MS supports VBA but it also provides newer MS Office solutions like Visual Studio Tools for Office. You can use the ".NET Data Provider for Teradata" with VS Tools for Office.

You must sign in to leave a comment.