>Hi Naomi, I think I have the latest version, it works for me in the Fox IDE but I dont think the OLEDB driver supports it

Let me quickly check, you're probably right.

Hmm, it's not listed in the unsupported commands

Unsupported VFPOleDB commands

and COPY TO command is listed in the supported functions. Perhaps there are still some unsupported formats, as you found.