Thanks, I'll take another look at OLE DB. It seemed an awkward way to get to VFP data so I didn't spend much time on it.

I've found a Select statement that produces the correct results although it loads the entire VFP table in another work area to do so. It may be too slow for use over a WAN.