Ian ;
If the user is using the query wizard is there a way to access the select statement from and exe not within FoxPro to get the exact statement and then apply some of my one code to it to create the dbf from the query.

PS.
Thanks to all for the responses. I'm going to try all of them to see what best suits the client.

Shawn