In VC.NET, when using the DAO to access the Access 2000 database, the field type used by the Create Table is used to build the field type of field type: ========================== ============================================================================================================================================================================================================= ============ Create Table Type | Field Type in Access 2000 -------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----------- Byte | Digital (bytes) -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ----- Smallinit | Digital (Integer) -------------------------------------------------------------------------------------------------- ------------------------------------------------ INT | Digital (long integer) ----------------------------------------- ------------------------------------------ Long | Digital (long " type)------------------------------------------------ --------------------------------------- Single | Digital (single precision) --- -------------------------------------------------- ---------------------------------- Double | Digital (double precision) -------- -------------------------------------------------- ------------ ------------------- Numeric | Digital (double precision)
-------------------------------------------------- ------------------------------------- Currency | Money --------- -------------------------------------------------- ---------------------------- Money | Money ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------- ------------------- Text (10) | Text, field size is 10 -------------------- -------------------------------------------------- ----------------- Yesno | Yes / No, equivalent to logical ---------------------- -------------------------------------------------- --------------- Date | Date / Time Date ----------------------------- -------------------------------------------------- -------- Memo | Remarks ====================================== ================================================== or The SQL command is good. The API of the table is always going to use.
No way, I have to create Table.
