Displaying Access Data in Excel

Posted on 2007-07-19
Last Modified: 2013-11-25
Hi Everyone-

I have, what I think will be, a very difficult question.  I do not even know if this is possible.

I have an excel workbook that just dumps information into an access table.  I created a query in access that sums totals based on the coresponding "service" with Group By.  I have created aform in access that a person can view this information.

What I need to do is be able to show that information back in excel.  I dont want it to show in a table format.  I would like for it to populate a specific cell with one of the "sumOf totals" from the access query.  The filter qould based on the the "service" name that is showing in another cell.  

I hope this provides enough insight for what I am trying to accomplsh.  Please let me know if I need to exaplin further.  Thank you so much for your help on this!

Question by:bclivell
    LVL 119

    Accepted Solution

    see this link.
    not a direct answer to your question but will give you an idea how to do what you want done.

    Using Automation to Transfer Data to Microsoft Excel
    LVL 29

    Assisted Solution

    There is a number of ways to display data back into Excel. In your case take a look at SQLRequest function. You can find a sample here:


    Author Comment

    Thank you both for the links.   But I am still having difficutly.  I just recently put the info into a SQL server db.  Right now, I have it set so that the entire table is pulled into an excel sheet and then I formulas pointed to that sheet.  But I am finidng that the excel file is getting very large everytime data is uploaded to the sql table.  

    I would llike for it to only bring in data specific to a certain project code stored in a cell instead of the whole table.  That SQLrequest, it appeared only worked on excel 2002.  Please correct me if im wrong.  This is all brand new to me.  Thank you again!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
    Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    779 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

    13 Experts available now in Live!

    Get 1:1 Help Now