Results 1 to 6 of 6

Thread: Export Query To Excel

Hybrid View

  1. Oct 25th, 2011, 10:15 AM #1
    TysonLPrice
    TysonLPrice is offline
    Wall Poster TysonLPrice's Avatar
    Join Date
    Sep 2002
    Location
    Columbus, Ohio
    Posts
    3,969

    Re: Export Query To Excel

    I'm not sure exactly what you want but you can put the query into Excel and run it when you open the spreadsheet. The user refreshes the data when it comes up. Look at the menu item "From Other Sources" in version 2007. I think it was "External data sources" in 2003.

    Basically you set up a connection.
    Step through selecting your tables etc.
    Edit the query Excel created replacing it with yours.
    And go

    http://excelusergroup.org/blogs/nick...rnal-data.aspx
    Last edited by TysonLPrice; Oct 25th, 2011 at 10:22 AM.
    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