"How can I create a table in SQL from VFP and populate it from a cursor?"

While I guess you could do that (maybe), it would be messy at best and you would have numerous security issues to overcome.
Normally you create the table in SQL via the SQL Management tools/scripts and then you insert records from VFP.

Following up on the previous sql pass through example.

******************************************************************
*** we have intHandle from the previous example
strSQL = [insert into Names (intPK, FirstName, LastName) values (1, 'Kevin', 'Emmrich') ]
intResults = SQLEXEC(intHandle, strSQL)

******************************************************************

Kevin