Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 19 May 2006 @ 14:25:07 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Excel Macro to get Teradata info into workbook
From:   Anomy Anom

<-- Anonymously Posted: Friday, May 19, 2006 10:20 -->

I am attempting to import some Teradata info into a workbook using some macros.

Below, I have some Public statements, and the compiler complains about the ADODB entries below.

Any suggestions on what I am doing wrong?

By the way, the Excel compiler error is: "User-defined type not defined."


     Option Explicit

     Public strLIMIT As String
     Public strATTRIB As String
     Public strTIME As String
     Public boolLimit As Boolean
     Public boolAttrib As Boolean
     Public errRow As Long
     Public rowcnt As Variant
     Public cnn As New ADODB.Connection
     Public rst As New ADODB.Recordset

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020