sqlexec(h, "create table mytable (field1 ..., ...)") select mycursor scan sqlexec(h, "insert into mytable (field1, field2, ...) values (?mycursor.field1, ?mycursor.field2, ...)") endscanIf 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.