Compilation in VBA code using DMO objects - Help

Compilation in VBA code using DMO objects - Help

Post by Noreen Bole » Thu, 02 Oct 1997 04:00:00



Please someone help - I can't get the AddObjectByName line to compile!!!

    Dim rstTable as SQLOLE.table

       oTransfer.CopyAllTables = False
         For Each rstTable In
gobjSQLServer1.Databases(strSourceDBname).Tables
           If StrComp(rstTable.Name, "equip_tbl") <> 0 And _
            StrComp(rstTable.Name, "parameter_class_tbl") <> 0 And _
            StrComp(rstTable.Name, "dod_class_tbl") <> 0 And _
            StrComp(rstTable.Name, "non_dod_class_tbl") <> 0 Then
               ' place in transfer object
              oTransfer.AddObjectByName(rstTable.Name, SQLOLEObj_UserTable)
              Debug.Print rstTable.Name
           End If
         Next rstTable

 
 
 

1. Compilation of VBA code - Help

Please someone help - I can't get the AddObjectByName line to compile!!!

    Dim rstTable as SQLOLE.table

       oTransfer.CopyAllTables = False
         For Each rstTable In
gobjSQLServer1.Databases(strSourceDBname).Tables
           If StrComp(rstTable.Name, "equip_tbl") <> 0 And _
            StrComp(rstTable.Name, "parameter_class_tbl") <> 0 And _
            StrComp(rstTable.Name, "dod_class_tbl") <> 0 And _
            StrComp(rstTable.Name, "non_dod_class_tbl") <> 0 Then
               ' place in transfer object
              oTransfer.AddObjectByName(rstTable.Name, SQLOLEObj_UserTable)
              Debug.Print rstTable.Name
           End If
         Next rstTable

2. UNION

3. DMO - using the transfer object - Help!

4. Date Format

5. invoking a query wizard using vba code

6. SQL Performance Analysis Tools!

7. Sharing problem writing to MDB file using WORD VBA code

8. Sybase FAQ: 1/16 - index

9. Code to duplicate a table structure using VBA

10. Sharing problem writing to MDB file using WORD VBA code

11. Need code example for merge replication using SQL-DMO

12. Trouble using backup object (Ref: SQL-DMO)

13. Error when creating a linked server object using SQL-DMO