Results 1 to 2 of 2

Export query without saving

  1. #1
    prag is offline Novice
    Windows Vista Access 2000
    Join Date
    Sep 2009
    Posts
    13

    Export query without saving

    Hello all,


    I need to export the results of query to a excel file. However, the query is connceted to a unbound object in a form that provides the parameter value to run the query. Now I need to export the result without saving the query. Does anyone know how to do this, this shouldn't be that hard for great programmers like all of you. Need help badly.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    the form must be open,,,, because it holds the criteria

    then open the query - it will display the results

    then export the query's records

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

Similar Threads

  1. Export Query to Various Excel Files
    By dalet in forum Import/Export Data
    Replies: 7
    Last Post: 11-09-2009, 09:22 AM
  2. Unable to close Query without saving
    By jhrBanker in forum Access
    Replies: 0
    Last Post: 06-08-2009, 05:09 PM
  3. Export a simple query result to an excel file
    By wop_nuno in forum Import/Export Data
    Replies: 1
    Last Post: 05-21-2009, 04:18 AM
  4. Combo Box isnt saving
    By calisen in forum Access
    Replies: 0
    Last Post: 09-11-2008, 03:34 PM
  5. Export Access reports/query results to Outlook Calendar/Task
    By kfinpgh in forum Import/Export Data
    Replies: 0
    Last Post: 02-22-2007, 01:09 PM

Tags for this Thread

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