Results 1 to 17 of 17

Thread: [RESOLVED]create a prompt in Excel and run a sql server query

Threaded View

  1. Jun 20th, 2006, 09:20 AM #1
    waely
    waely is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2002
    Posts
    150

    [RESOLVED]create a prompt in Excel and run a sql server query

    hi,
    I usually run a query against sql server by going to Get external Data --> run database query.

    can someone instruct me to how I can embbed a prompt in excel so when someone opens the excel spreadsheet they would get the prompts with paramters that they want to pass to the query?

    the prompts must be a dropdown list populated from query then the final step is running last query with the three parameters they selected.

    thank you very much for any help.
    waely
    Last edited by waely; Jun 22nd, 2006 at 01:41 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width