Access Table export to specific cells in Excel.

[CoolFactor]

I want to export this Access table into Excel in the following way I describe below.

Below you will find the simple table I am trying to export to Excel.

strFY AccountID CostElementWBS CostElementTitle
2008 1 7 Integrated Logistics Support
2008 1 7 Integrated Logistics Support

I want to export the 1st record of this table to excel workbook "Test 1," in the following way:

In Workheet "Sheet1," I want the data pertaining to field strFY to go to Cell "A1," and then I want the data pertaining to field AccountID to go to Cell "A2."

Then in Worksheet "Sheet2," I want the data pertaining to field CostElementWBS to go to Cell "B1," and then I want the data pertaining to field CostElementTitle to go to Cell "B2."

FOR THE SECOND RECORD IN THIS TABLE:

I want to export the 2nd record of this table to excel workbook "Test 2," in the following way:

In Workheet "Sheet1," I want the data pertaining to field strFY to go to Cell "A1," and then I want the data pertaining to field AccountID to go to Cell "A2."

Then in Worksheet "Sheet2," I want the data pertaining to field CostElementWBS to go to Cell "B1," and then I want the data pertaining to field CostElementTitle to go to Cell "B2."

A step by step process would be much appreciated.

Thank you.