Import and Compare


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Import and Compare

  1. #1
    Vincent Guest

    Import and Compare


    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
    Share on Google+

  2. #2
    deborah Guest

    Re: Import and Compare


    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


    Share on Google+

Similar Threads

  1. Getting a GUI to run
    By Eric in forum Java
    Replies: 4
    Last Post: 04-14-2006, 09:09 AM
  2. Replies: 1
    Last Post: 03-16-2005, 05:45 PM
  3. Getting a GUI to function
    By Eric in forum Java
    Replies: 1
    Last Post: 11-27-2001, 06:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center