Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tyo
  • Order by date
  1. tyo

    ODBC call failed?

    what's wrong with this code, i was trying to create a connection to sql server 7 database in vba code. but when i run it, it keeps telling me run time error , ODBC call failed? anybody could hele me, thank u very much! Sub QueryFN() Dim numberOfRows Dim wrkODBC As Workspace Set wrkODBC =...
  2. tyo

    create a connection to a SQL Server 7 database

    thanks, but i have to use vba code to create a connection.
  3. tyo

    create a connection to a SQL Server 7 database

    i'm very new here, trying to create a connection to a sql server 7 database in excel vba, this is the code i just wrote, but doesn't work, thanks in avance for any help! sub Query Dim wrkODBC As workspace Set wrkODBC = CreateWorkspace("ODBCworspace", "", _...

Part and Inventory Search

Back
Top