• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

Displaying Access Data in Excel

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!

-Brian
0
bclivell
Asked:
bclivell
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
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
http://support.microsoft.com/?kbid=210288
0
 
leonstrykerCommented:
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:

http://www.bygsoftware.com/Excel/sqlrequest.html

Leon
0
 
bclivellAuthor Commented:
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!!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now