Try the following conversions. This is what I use....by the way, these are DAO enumerated field type constants:

&& cFDataType = Fox Data Type
&& nADataType = Access (DAO/ADO) data type.
DO CASE
CASE cFDataType="C"
	nADataType=10
CASE cFDataType="D" OR cFDataType="T"
	nADataType=8
CASE cFDataType="L"
	nADataType=1
CASE cFDataType="M"
	nADataType=12
CASE cFDataType="N" OR cFDataType="F"
	nADataType=7
CASE cFDataType="I" 
	nADataType=4
CASE cFDataType="Y"
	nADataType=5
CASE cFDataType="G"
	nADataType=11
ENDCASE

>I am trying to dynamically create Access 2000 tables (not an entire .mdb file) with VFP code. I can create a table, but it will only let me create character fields. If I use any other field types, it will not create it. However, I also do not get an error message. Any suggestions or ideas would be greatly appreciated.
>
>Steve