嘿！有這個對應表的話，用程式來建立資料表就方便多了。
由於用 asp + oldeb for foxpro，所以要參考 Oledb 的部分。
ADO Data Types與數據庫值對應 http://www.zaoxue.com/article/tech-48473.htm
| DataType Enum | Value | Access | SQLServer |
|---|---|---|---|
| adBigInt | 20 | BigInt (SQL Server 2000 +) | |
| adBinary | 128 | Binary TimeStamp | |
| adBoolean | 11 | YesNo | Bit |
| adChar | 129 | Char | |
| adCurrency | 6 | Currency | Money SmallMoney |
| adDate | 7 | Date | DateTime |
| adDBTimeStamp | 135 | DateTime (Access 97 (ODBC)) | DateTime SmallDateTime |
| adDecimal | 14 | ||
| adDouble | 5 | Double | Float |
| adGUID | 72 | ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB)) | UniqueIdentifier (SQL Server 7.0 +) |
| adIDispatch | 9 | ||
| adInteger | 3 | AutoNumber Integer Long | Identity (SQL Server 6.5) Int |
| adLongVarBinary | 205 | OLEObject | Image |
| adLongVarChar | 201 | Memo (Access 97) Hyperlink (Access 97) | Text |
| adLongVarWChar | 203 | Memo (Access 2000 (OLEDB)) Hyperlink (Access 2000 (OLEDB)) | NText (SQL Server 7.0 +) |
| adNumeric | 131 | Decimal (Access 2000 (OLEDB)) | Decimal Numeric |
| adSingle | 4 | Single | Real |
| adSmallInt | 2 | Integer | SmallInt |
| adUnsignedTinyInt | 17 | Byte | TinyInt |
| adVarBinary | 204 | ReplicationID (Access 97) | VarBinary |
| adVarChar | 200 | Text (Access 97) | VarChar |
| adVarWChar | 202 | Text (Access 2000 (OLEDB)) | NVarChar (SQL Server 7.0 +) |
