Hi Michael,
>To create a table via VFP's ODBC driver the SQL command syntax would be:
>
>CREATE DBF TableName (FIELD1 FieldType (width [, precision]),FIELD2 FieldType (width [, precision]))...
>...Check VFP's help under CREATE TABLE SQL for more information.
>Note that you must include the destination path of the DBF to be created regardless of the DSN source. The above code works with latest VFP ODBC driver configured for FREE tables. I have not tested with VFP's ODBC DBC container nor have I used VFP's odbc driver with cold fusion.
>
>HTH,
>Mike

Sorry I have not had a chance to try the code, I hope to give it a go today. Thanks for your suggestion, I'll let you know how it turns out.
Have a Great New Year.

Ed