+ Reply to Thread
Results 1 to 2 of 2

Pull certian info from Access into Excel based on data input

  1. #1
    Registered User
    Join Date
    02-21-2019
    Location
    Philadelphia
    MS-Off Ver
    Office 2016
    Posts
    48

    Pull certian info from Access into Excel based on data input

    Basically I have this database in Microsoft Access of incidents that happen in my stores. The overwhelming majority of incidents are minor and don't need further analysis. Some, however, need to be reviewed with our store management team. I typically just pull all the necessary info from Access and drop it into a Word document. But its tedious to do weekly and can lead to mistakes in manually pulling the info. I was wondering if there was a way to have excel automatically pull the necessary incidents into a spreadsheet automatically. I know there's a way to link up the two applications, but I don't know how to get excel to only pull what I need.

    Basically, if one column says "yes", (column E) excel would pull and drop in roughly 4 more data sets (columns A through D) from the same access entry (date, store name, description, employee who submitted it). If that same column says no, excel wouldn't pull in this incident's info.

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

    Re: Pull certian info from Access into Excel based on data input

    Create a query in Access and then export the query to Excel. Once the query is built, right click on the query in the navigator and select export 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 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: 03-30-2016, 09:08 PM
  2. Replies: 0
    Last Post: 07-08-2015, 06:31 AM
  3. Pull data based on user input
    By mani_bbc05 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-14-2013, 03:39 PM
  4. Replies: 5
    Last Post: 11-06-2012, 07:17 PM
  5. Replies: 7
    Last Post: 12-06-2010, 10:55 PM
  6. Excel 2007 : Pull Data from Cells based upon User Input
    By FLEXCopMNPD in forum Excel General
    Replies: 2
    Last Post: 02-23-2010, 12:02 AM
  7. [SOLVED] Pull info from access to template in excel?????
    By jwr in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-26-2005, 11:05 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