I have a "simple" program to write. Need to read an Access table, perform some calcs, then write new records out to a different Access table. Got a book on ADO and I'm not quite there yet.
I have attached the following test code. I've found that when I declare 2 tables, the 2nd one seems to be ignored. I proved this because the table TITLES does not exist in Extracts.MDB.
Questions;
1. To write output records only to a file, do I still need to Open it with a "Select" statement?
2. In sample code, how would I modify code so I can read/update two independent tables.
Thx in advance,
GlenEllis
I have attached the following test code. I've found that when I declare 2 tables, the 2nd one seems to be ignored. I proved this because the table TITLES does not exist in Extracts.MDB.
Questions;
1. To write output records only to a file, do I still need to Open it with a "Select" statement?
2. In sample code, how would I modify code so I can read/update two independent tables.
Thx in advance,
GlenEllis