Automatically Insert into Access Tables

  • Thread starter Thread starter Mac@440th
  • Start date Start date
M

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?
 
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?
|
 
Back
Top