Export To A Specific Cell of an Excel sheet

[CrystalVis]

i'm trying to export a total from a sql table to a specific cell of an excel sheet. for exampl,
select total_amount from tbl_total
to cell b24 of an excel sheet named DATA. right now i have a data pump between a source connection and an excel connection but not sure how to accomplish his. any help/suggestion/example is greatly appreciated. thanks

 

[PHV]

Why not pull the data in Excel with a QueryTable (menu Data -> External data -> New query)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CrystalVis]

i'm trying to accomplish this within a dts package. there are other sql tasks that are pulling the data to create the total amount.