Search results

  1. S

    Access table is not recognized when referring it from VBA

    Hi, I am facing some issues when trying to fetch records from an Access table. Below is the VB code, coded in an access file where the table BkupData exist, the data base is 'Database2' which is in C drive. The select query giving error message that the table 'MyUserID.BkupData' is undefined...
  2. S

    Importing DB2 table into Access VBA

    Hi, I have a requirement to data mainframe DB2 table and compare it with the other table stored in same access file. I am able to connect to the DB2 table successfully using OLE DB and trying to use ‘SELECT INTO’ phrase to create another table in the same access file so that I can compare...
  3. S

    Importing Mainframe DB2 table into Access

    Thanks Jdraw, I have not tried this. Will try that out. But I am going to give this to Business people who do not know this technical stuff, and mainthing is I am going to automate the process, business person can just click one button in access/excel and it should display the discrepancy...
  4. S

    Importing Mainframe DB2 table into Access

    Hi, I have a requirement to import data from a mainframe DB2 table and compare it with the other table stored in same access file. I am able to connect to the DB2 table successfully using OLE DB and trying to use ‘SELECT INTO’ phrase to create another table in the same access file so that I...
Back
Top Bottom