I have a prospective client who wants to pass their data on to other organziations who will be using Microsoft Access.

The data is fairly simple - 2 main tables. The first has personnel records, the second training classes attended. I picture generating, for Access, a single table w/one record per training class attended by each person.

I use VFP 6 - what is the best way to approach this (if at all)? EXPORT, COPY TO?

I just tried to COPY TO file FOX2X, then opened the file in Access 2000, and a logical field was translated to numeric (.T. --> -1). Any advice is appreciated.

TIA. J