+ Reply to Thread
Results 1 to 2 of 2

Open an Access Query Quickly in Excel

  1. 12-28-2015, 12:52 PM #1
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Open an Access Query Quickly in Excel

    Ran across this today. It is so easy.

    http://datapigtechnologies.com/blog/...ults-to-excel/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  2. 12-28-2015, 01:06 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Open an Access Query Quickly in Excel

    Yes, It is pretty cool. I've been doing this with all versions of excel starting with v. 2003. The only issue I had is with importing union queries. For some reason they were not visible when you browse.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is it Possible to Open an Access Database Query and copy results
    By gassiusmax in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2015, 07:24 AM
  2. Help!! unable to open Query in access
    By LauraForiero in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-22-2013, 10:36 PM
  3. Can Outlook open query in Access?
    By jgomez in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 12-17-2012, 12:02 AM
  4. Excel Command button to open a Microsoft Access query
    By Bineyo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2012, 04:31 PM
  5. Excel still open after Query retrieve from Access
    By Hans_Gruber in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2009, 07:14 PM
  6. Open an Access database Import data like Microsoft Query
    By hilander in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2007, 06:55 PM
  7. [SOLVED] How to open Access recordset via Query in Excel VBA???
    By Hexman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2006, 03:15 PM

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1