>My Foxpro table does not exist yet. The SQL table structure is always unknown. Then I do not have a Foxpro template, I just need a command to do both... create foxpro table and copy data from sql to dbf. How can I do that in easy way?
Did you know SQL Server Table Name? :-)
If so your question is for VFP forum :-)
In VFP (w/o any error handling):
lnSQLH = SQLSTRINGCONNECT(.....)
SQLEXEC(lnSQLH,[SELECT * FROM SqlTableName],[MyCursor])
SELECT MyCursor
COPY TO MyVFPTable
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.