Create table with field type text creating as memo

the following

            "CREATE table " & acObj.pullTBLNAME & " ( DATES number,A Text, B Text, C Text, D Text, E Text, F nu开发者_如何转开发mber, G number,H number)"  

is creating a table with data types of number and data types of MEMO not the desired type of TEXT.

any help would be greatly appreciated

Specify a field size:

"CREATE table " & acObj.pullTBLNAME & _
" ( DATES number,A Text(20), B Text(255), C Text, " & _
"D Text, E Text, F number, G number,H number)"

Also,

  (DATES number, A CHAR,...)

works as well.