Results 1 to 3 of 3
  1. #1
    IncidentalProgrammer is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2014
    Location
    Texas
    Posts
    156

    Possible to Import data and replace some, but not all, in table?

    Hi, all!



    I know this is likely a silly question, but I'm still pretty new to Access, and just now starting to look at importing data. I've tried Google, but I haven't been able to find an answer for this.

    My database is going to be taking in claim information in two ways: imports from the main database going forward, and manual entry of claims that predate that system, and corrections to claims that come from it with errors. My question is, if I have one table for claims, can I set up the import to only update those where the claim # matches, leaving the manually-entered claims as they are? Also, is there any way that I might be able to spare fields in the previously imported claims that have been corrected by users?

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    not in one import step - no. you need to import into a temp holding table. that's the import. then you need to develop queries that correctly define & result in those records that should either append into the Claims table or Update the Claim table ....2 different sets of queries.... and trigger those correctly...

  3. #3
    IncidentalProgrammer is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2014
    Location
    Texas
    Posts
    156
    That sounds great, and makes my life easier! Thanks, NTC!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA - Import Excel Data into Access Table
    By sikhinvestor in forum Import/Export Data
    Replies: 2
    Last Post: 04-28-2014, 01:43 PM
  2. Replies: 9
    Last Post: 03-25-2013, 02:30 AM
  3. Import data from Outlook e-mails to table
    By Lusitan in forum Import/Export Data
    Replies: 9
    Last Post: 07-11-2012, 12:17 PM
  4. Import data from Excel to table on click
    By mrbabji in forum Import/Export Data
    Replies: 1
    Last Post: 04-19-2012, 05:15 PM
  5. Import Data from a Table in the Body of an Email
    By a1195423 in forum Import/Export Data
    Replies: 0
    Last Post: 03-24-2011, 01:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums