Automatically Insert into Access Tables

[Mac@440th]

I have developed 2 tables in Access using FP's Database Wizard. Table
"A" is a daily working table that my clients tap into all day long.
Table "B" is a table, using same design schema as Table B that I
receive from higher headquarters on a weekly basis. I have developed
an ASP script that steps through each record in Table B and compares
with same record in Table A, if a difference is found in any of the
fields, a listing is displayed on a HTML page.

I want to historically capture the differences and place in a 3rd
table (Table C) with the date of each comparison. Is there a way, via
ASP or ASP.NET, to step through each record in "B" compare it to data
in "B" and and input any differences into Table C?

 

[Stefan B Rusynko]

Yes
When you are running your comparison for differences (A to B) and find one to display as a difference
- open table C & add the date/time and the Table B / Table A field content
(in the same field name structure doubled in Table C as say FieldnameA & FieldnameB)

You could also run the query twice
- first time as is to display results
- second time to compare but not display (just update C)
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have developed 2 tables in Access using FP's Database Wizard. Table
| "A" is a daily working table that my clients tap into all day long.
| Table "B" is a table, using same design schema as Table B that I
| receive from higher headquarters on a weekly basis. I have developed
| an ASP script that steps through each record in Table B and compares
| with same record in Table A, if a difference is found in any of the
| fields, a listing is displayed on a HTML page.
|
| I want to historically capture the differences and place in a 3rd
| table (Table C) with the date of each comparison. Is there a way, via
| ASP or ASP.NET, to step through each record in "B" compare it to data
| in "B" and and input any differences into Table C?
|