I already have a database with no tables.

I want to execute a SQL statement that will create a table based on the results of the query. This is easily done in MS Access. But when I try to do this in VB6, I get an error.

What form should the SQL statement take and is it appropriate to use a QueryDef object?

Thanks.