Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006

    Search for multiple records


    I have a database at work that keeps an inventory of cameras by location. Every week I get a repair estimate sheet that lists cameras by serial number that need to be repaired. This list is sent to me in excel. I am trying to make it where I can just copy the column of serial numbers from the excel list sent to me and paste it directly into the database to return my information for those cameras. I would like to do this in a datasheet view where I paste the column, it looks them up and returns the information I need(warranty dates) by serial number. Any help would be greatly appreciated. Thanks.


  2. #2
    LukeJ Innov is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013

    Can't you just open up the table where the data is installed and paste the data there? Than create a query that allows you to search for the data you want?
    Or am I not getting you question?


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

Similar Threads

  1. Inserting multiple records into a table
    By New2Access in forum Programming
    Replies: 1
    Last Post: 07-07-2011, 09:18 PM
  2. multiple fields in separate records
    By Fredo0709 in forum Database Design
    Replies: 9
    Last Post: 04-09-2010, 12:23 PM
  3. Recalling Records from a Combo search
    By Dreamcatcher in forum Forms
    Replies: 0
    Last Post: 08-18-2008, 07:33 AM
  4. Linking Multiple records
    By in forum Programming
    Replies: 0
    Last Post: 02-14-2008, 09:18 AM
  5. How do I choose multiple records for a report
    By admaldo in forum Reports
    Replies: 2
    Last Post: 03-03-2006, 06:02 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
Other Forums: Microsoft Office Forums