On Excel, it's easier (and better) to use Excel VBA to populate data than using SendKeys in Access.  E.g.:

Cells(2, 3) = "This puts data in C2 on the current worksheet"

I avoid using SendKeys whenever I can.

Thanks Kevin, would you be able to give me an example of the line of code to do that?

You can use the exact code I used in my example.  In Excel, you can try the code in the immediate window (see pic).  If it works, put in into your procedure.

The syntax is Cells(row num, column num).''So:

Cells(2, 1) is A2
Cells(3, 1) is A3
Cells(4, 1) is A4, and so forth.

To refer to the cells with A2, A3, A4, etc., use Range():

Range("A2") or Range("a2")

But the numeral indices used by Cells() allow you to loop though a range of cells with ease:

For i = 1 to 10
     For j = 1 to 100
          Cells(j, i) = j
     Next j
Next i

The above fills A1 to E100 with numbers.

With these methods, you can fill out an Excel sheet in any systematic ways you want.

Mark, I've shown some examples of automating Word from Access, like here: Document Index.

I've got some Excel automation videos coming out soon. For example, you can't use Excel's stock history & pricing functions unless you use Automation.

Great stuff guys!