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 derfloh 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: *

  1. nitemarepc

    Client Access ODBC & SQL

    I am using VB6. I have found someone who says this can be done with ADO with an ODBC connection to both the 400 tables and Access.
  2. nitemarepc

    Client Access ODBC & SQL

    I tried the SELECT * INTO [New Table] FROM [400 Table] and I get the error of ODBC connection failed. I could loop through the recordset for the query of the 400 table but we are talking about a huge table. I thought there should be a way to bridge the 400 table into a new Access type table...
  3. nitemarepc

    Client Access ODBC & SQL

    I need the table on the local drive to be in .mdb (Access) format. I will be using the tables to generate a report in VB6 Crystal Light.
  4. nitemarepc

    Client Access ODBC & SQL

    I want to use the Client Access ODBC to connect to the AS400 and run an sql to create a work table on the local c:. I can connect and create a query with a sql but cannot create a local table with the sql. HELP!!
  5. nitemarepc

    Foxpro 2.6 & VB 6 - Accessing files

    I have tried to access the Foxpro 2.6 files with Visual Basic 6 using SQL with no luck. This is the code and according to everything I have read and the help with Visual Basic, it should work. I get an error of invalid argument for the append (dbtempdest.TableDefs.Append tdtempdest1). I need...

Part and Inventory Search

Back
Top