I am using Office 2003 on Win XP with ADO 2.8 Object Library and ADO ext 2.8
for DLL and Security. Also have a ref to Access object library.

I know it is possible to create a table in Access from Excel by using ADOX.

Is it possible to create a table in Access from Excel by defining the table
in SQL?
Then deliver the SQL using the ADO execute method. I thought that you could
and that somewhere I had done it.

I am trying the following syntax without luck:
CREATE TABLE tablename (field1 VARCHAR NULL, field2 VARCHAR NULL)

Can someone please correct my SQL or otherwise refresh my memory on this?
Thanks in advance.