Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access External data > Query to Excel ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 10853 of 11313
Post > Topic >>

Query to Excel Spreadsheet

by =?Utf-8?B?U2NhZ25ldHRp?= <Scagnetti@[EMAIL PROTECTED] > Jul 29, 2008 at 07:54 AM

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
 




 1 Posts in Topic:
Query to Excel Spreadsheet
=?Utf-8?B?U2NhZ25ldHRp?=   2008-07-29 07:54:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 19:40:20 CST 2008.