I'm not sure where to post this, but thought I would start here .....

Overall, I want to have a Workbook sit on a server somewhere, and have it
set up to reference a datasheet that gets filled in later. Imagine I have a
Pivot table defined on a worksheet named "PivotSheet" in an Excel workbook
named "DataBook" that points to a worksheet named "DataSheet", which starts
empty.

A web server (ColdFusion) does it's thing, and eventually executes a query
from a database. I would like the web server to make a copy of DataBook, and
dump the results of the query into DataSheet (thereby populating the Pivot
table data), and make this new file available for download to the web user.

I'm presuming Excel is not installed on the server, just the "template"
DataBook.

Is there a way, using ODBC or something else, to put the result set into a
specific worksheet in a closed Excel Workbook?

Thanks, Bob