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...
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...
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...
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...