Import and Compare

[Vincent]

I am importing a text file into Access. I have used a simple Macro to accomplish
this task and it is running nicely. However, I must now bring the text into
the table, then compare it to an existing table, record by record.
1) If the records are the same,
then I want to keep it as is;
2) If the records are different (These records will have the same key, but
some of the data in the other fields are different)
then I want to display the record with the changes, but
also indicate to the user the record changed by flagging it
3) Those that are completely new
just append.
I can see this in a structured language, but I have to get it into VBA to
facilitate the load into Access.

Is this terribly complicated? Is there some reference or guide I can use?
I am afraid this one has me puzzled.

Vincent

[deborah]

Hi Vincent -

You can import your new information into a different table, then write VB
or VBA code to process the records in the new table and move them into the
existing tables appropriately.

Good luck!
Deborah
"Vincent" <vryder@onepointcom.net> wrote:
>
>I am importing a text file into Access. I have used a simple Macro to accomplish
>this task and it is running nicely. However, I must now bring the text
into
>the table, then compare it to an existing table, record by record.
>1) If the records are the same,
>then I want to keep it as is;
>2) If the records are different (These records will have the same key,
but
>some of the data in the other fields are different)
>then I want to display the record with the changes, but
>also indicate to the user the record changed by flagging it
>3) Those that are completely new
>just append.
>I can see this in a structured language, but I have to get it into VBA to
>facilitate the load into Access.
>
>Is this terribly complicated? Is there some reference or guide I can use?
> I am afraid this one has me puzzled.
>
>Vincent