Query to Excel Spreadsheet

S

Scagnetti

I've created a query (see below) in Access 2003 that sums data and returns
one and only one row. I want to transfer that data to a named Excel
spreadsheet but in specific cells. For example, I want to put 'SumOfSalary'
into cell D73, 'SumOfBonus' into cell K78, etc. Can this be done in VBA?
I've been looking at DoCmd.TransferSpreadsheet but I'm not getting very far.

Here is the query:
SELECT Sum(Employee.Salary) AS SumOfSalary, Sum(Employee.Bonus) AS
SumOfBonus, Sum(Employee.ShareOption) AS SumOfShareOption
FROM Employee;

Named spreadsheet: C:\EmpComp.xls
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top