Results 1 to 2 of 2
  1. #1
    Nori is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2015
    Posts
    3

    Import the search criteria to the access and search three tables and get the result back in excel



    Hello All,
    I have 2 different tables in access database. All the search criteria (multifield - textbox, date, numbers)are in excel sheet. I need to import these criteria in access and do the search on these 2 tables and get the result back in excel with the name of the table that generate the results.
    I know sql but beginner for access. Please help me here!!!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Not really understanding. Maybe you need to import or link the Excel sheet then do a query that links tables on the common fields and export records of this query.
    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. Search Form - Dialog box asks for search criteria
    By faythe1215 in forum Queries
    Replies: 3
    Last Post: 02-10-2015, 05:54 PM
  2. Replies: 3
    Last Post: 01-04-2015, 06:09 PM
  3. Import Excel spreadsheet Search key not found error
    By synses in forum Import/Export Data
    Replies: 1
    Last Post: 07-01-2013, 11:05 AM
  4. Replies: 5
    Last Post: 07-13-2012, 01:15 AM
  5. Highlight key search result
    By uronmapu in forum Access
    Replies: 28
    Last Post: 06-17-2012, 09:32 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