Inserting data from Access to an EXCEL spreadsheet

[Marilyn]

How do I place information from an Access table into a
specific row and column of an EXCEL spread sheet? I will
be writing VBA in Access 2000 to do this process.
For example:
Authorized Dollars: 3,000 Authorized Hours: 200

Budgeted Expended
Task A: 1,000.00 200.00
Task B: 3,000.00 50.00

Authorized Dollars and Authorized Hours labels are fixed
labels but Task A, Task B are descriptions that would come
from the database. The numbers are values from the
database as well.

 

[Van T. Dinh]

Use Automation with Access as client and Excel as server.

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=253235