+ Reply to Thread
Results 1 to 2 of 2

Parameter Query that takes parameter value from Excel Cell

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    49

    Parameter Query that takes parameter value from Excel Cell

    Hi Guys,

    The code below does what I need- It runs a simple parameter query in Access by using the parameter value from Excel cell , it then pastes the output back to Excel file. I just started working with Access and don't get why it only works with a Select query. What do I do to make it work with a query that is saved as "Make Table" Query that creates a table called "Table1"?

    Thanks a lot!


    Please Login or Register  to view this content.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Parameter Query that takes parameter value from Excel Cell

    Look at this link. I have never run an action query from Access as I find it easier and simpler to just run them in Access. However, look:

    http://www.mrexcel.com/forum/excel-q...ery-excel.html
    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 to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 11-12-2013, 03:57 AM
  2. Parameter query in excel cell for multiple parameters
    By dinker454 in forum Excel General
    Replies: 0
    Last Post: 10-31-2013, 02:58 PM
  3. Parameter Query - Bad Parameter Type
    By Kyle123 in forum Excel General
    Replies: 0
    Last Post: 04-23-2013, 01:06 PM
  4. Replies: 0
    Last Post: 04-12-2013, 10:16 AM
  5. Replies: 5
    Last Post: 04-26-2006, 07:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1