Launch BTEQ File from VBA

Tools & Utilities
Enthusiast

Launch BTEQ File from VBA

Hello,

Can you help me to launch a BTEQ File from Visual Basic Access and put the result in ListBox for example?

Thank U

Nadejda

1 REPLY
Enthusiast

Re: Launch BTEQ File from VBA

To be honest, I have never used VB with Teradata. I had a direct configuration from excel with some programming.

After connection , can you try with this logic:

after logon........

.import vartext file=abc.txt;

using empno(varchar(1)) select * from abc.emp where emp_no=:empno;

.LOGOFF;

.QUIT;

Also,maybe you can try with this link if you are reading from a file.


I suggest , you search in the net , how to populate listbox from a file as per your reqt.

Cheers,