Simple Field question

[Stuart]

I cannot find a way to set the data type for a field
when creating a new database with code.

Specifically, I wish to set Field 2 to Memo, ready
for large text data via an import from Excel.

Can anyone help, please?

Regards.

 

[onedaywhen]

CREATE TABLE Blah
(
ID INTEGER NOT NULL,
GenComment MEMO NULL
)
;