Access backend and Excel Front End

Posted on 2011-05-13
Last Modified: 2012-05-11
Id like to see how to link Excel and Access with Access as the backend.
Id liek to create a report in e/xcel using access as the db.
Question by:zachvaldez
    LVL 44

    Expert Comment

    In Excel, click File, Open, File of Type (mdb, mde), Browse for the file, click, brose for the table or query.

    Author Comment

    Can I send a result of a query to display as excel spreadsheet?
    LVL 12

    Accepted Solution

    "Can I send a result of a query to display as excel spreadsheet?"

    It is possible to go either way between Access and Excel. To pull data from an existing query, first set up the query in the Access database, then open your Excel front-end and go to the Data menu and choose "From Access". Browse to your database, then follow the prompts to choose the query you want and where you want to put it in your file. The result will be a linked table that pulls its data from the Access query. You can refresh the data by using the Connections option from the Data menu.

    Author Comment

    Can u show me a macro or automated way to implement it?
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Some Notes:

    1. Access has much more powerful Reporting facilities than Excel does.
    What type of Report are you creating in Excel, that can't be recreated in Access directly?

    2. Just be aware that currently you cannot update the Access data via the Excel "Front End"

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now