+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP in Excel to Retrieve Data from Access Database?

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    Chicago, IL
    MS-Off Ver
    Office 365
    Posts
    5

    VLOOKUP in Excel to Retrieve Data from Access Database?

    Hi, I'm not sure if this is the best part of the forum to ask this question in, but since I use Office 365 I'm guessing it's a good start.

    Is there anyway I can use a VLOOKUP function in Excel to retrieve data from an Access database? I have a large worksheet in Excel that I want to move to Access, but I still want to use VLOOKUP to retrieve values from it.

  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,811

    Re: VLOOKUP in Excel to Retrieve Data from Access Database?

    You would not use Vlookup. Instead you would create a parameter query in Access.

    https://www.thesmallman.com/parameter-query-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

  3. #3
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: VLOOKUP in Excel to Retrieve Data from Access Database?

    Details needed. Do you mean you want to move a data in a large Excel worksheet to Access as a table? Are there VLOOKUP formulas in that Excel range which you want to convert into an Access table? If so, you could import tables of constant values from Excel into Access tables, then use queries in Access to produce query results as tables (they'd be called views in other DBMSes), For example, if most of your data were in TableA but you wanted to add values from TableB's foo field based on common bar field in TableA and TableB, perform an inner join on the 2 tables to produce just the records which have bar field entries in common between the two tables, or perform an outer join so that the foo field would be NULL in the query result for bar field entries in TableA with no corresponding record in TableB.

+ 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. retrieve data from access database into an excel cell
    By chubbychub in forum Excel General
    Replies: 13
    Last Post: 07-29-2019, 10:18 PM
  2. Data Restriction Retrieve from Excel/Access
    By AMIVELD in forum Excel General
    Replies: 1
    Last Post: 09-25-2015, 09:03 PM
  3. Replies: 2
    Last Post: 07-05-2013, 09:37 AM
  4. Retrieve access data into excel
    By hutty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2007, 10:41 AM
  5. [SOLVED] Retrieve Data from SQL database Programatically using Excel VBA
    By ebferro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2005, 12:30 PM
  6. [SOLVED] How to get Excel to retrieve aggregate data from Access
    By Don MacKinnon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2005, 03:15 PM
  7. VBA coding to retrieve data from Access to Excel :S
    By Vicks in forum Excel General
    Replies: 2
    Last Post: 09-28-2005, 12:05 AM

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