Results 1 to 2 of 2

Large Table Update

  1. #1
    drunkenneo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    199

    Large Table Update


    I have a table in database, with pk as internal no and in normalised form.

    Here user will import an excel with the information having internal no, my task is to match the internal no and update the required row with the data.

    How ever i can do it, by running set of queries, i want to know if there any more quicker side, where u can compare first the entries and not matching then update, yes it will be the case if blank also there.

    any help

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,050
    Linking to or importing the spreadsheet then running UPDATE or INSERT action queries is probably the fastest and easiest, assuming the spreadsheet structure allows linking/import. Otherwise, VBA can open the spreadsheet as an object in code and read each cell one at a time. Complicated code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 8
    Last Post: 11-07-2013, 08:33 AM
  2. Replies: 1
    Last Post: 02-08-2012, 04:50 PM
  3. Optimising lookups in a large fixed table
    By u38cg in forum Queries
    Replies: 4
    Last Post: 06-22-2011, 08:21 AM
  4. Replies: 1
    Last Post: 01-22-2011, 12:23 PM
  5. Median and Mode for a large table
    By brandon in forum Access
    Replies: 0
    Last Post: 05-08-2008, 09:26 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
  •  
Tech Forums: Microsoft Office Forums