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

You send a CREATE TABLE command and then a bunch of insert statements... in metacode

sqlexec(h, "create table mytable (field1 ..., ...)")
select mycursor
scan
   sqlexec(h, "insert into mytable (field1, field2, ...) values (?mycursor.field1, ?mycursor.field2, ...)")
endscan

If it's a temp table, then prefix it with # on SQL side and issue a "drop table #mytable" when you don't need it anymore.

Error handling, optimization (like not sending more than one statement per sqlexec()), and actual fields are left as en exercise to the reader :).