>Does anyone know of a way to create a VFP table from a SQL Server table? > >TIA,
SQLEXEC(sqlH, "SELECT * FROM SqlTable WHERE 1=0","crsVFPCursor")
SELECT crsVFPCursor
** 1.Using AFieldsAFIELDS(laFlds)
CREATETABLE MyVfpTable FROMARRAY laFlds
** 2. Just copyCOPY crsVFPCursor TO MyVfpTable && See HELP for details
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller The only thing normal about database guys is their tables.