CREATE DATABASE C:\TEMP\yourdbc

lnHandle = SQLCONNECT("PROD", "USERID", "PASSWORD")
SQLEXEC(lnHandle, "select * from whereever")

COPY TO c:\temp\whereever DATA c:\temp\yourdbc


Do this several times to pull your data down to vfp levels. To reverse the process, you can create a view and append from these tables. The long field names will be preserved.