Exporting resource data to Access

[DAVEKELLY]

Article 'Using DAO to Export Data to Microsoft Access' from MS describes exporting from Project data to Access.

Defining the Access Table:
projtable.Fields.Append projtable.CreateField("Start", dbDate)

and

Exporting the data:
![Start] = task.Start

This works fine, but I am having difficulty exporting the task Resource Name data.

I have tried and failed using:

projtable.Fields.Append projtable.CreateField("Resource", dbText)

and

![Start] = Assignment.ResourceName

and numereous other combinations.

Any pointers?

Thanks

Dave