I'm using ODBC to read/write on a Microsoft Access database. I have to create a table but I don't know how to create the query because I have some problems with data type
I have to create a table, "Data", with 5 fields. Volt, Ampere, Celsius and Joule are floating numbers ( SINGLE, 4 bytes width, 2 digits precision ) and Seconds is an integer number ( INTEGER, 2 bytes width ).
Can someone help me creating this table :
CREATE TABLE Data ( Volt ......
Thanks
I have to create a table, "Data", with 5 fields. Volt, Ampere, Celsius and Joule are floating numbers ( SINGLE, 4 bytes width, 2 digits precision ) and Seconds is an integer number ( INTEGER, 2 bytes width ).
Can someone help me creating this table :
CREATE TABLE Data ( Volt ......
Thanks
hmm... maybe Icz ODBC tut can help on this.
regards
regards
There are no create table examples in ODBC tut
try this: CREATE TABLE Data (Volt FLOAT, Ampere FLOAT, Celsius FLOAT, Joule FLOAT, Seconds INT)
for detailed description on data types look into the M$ access help file.
This is not your homework, isn't it ? :)
for detailed description on data types look into the M$ access help file.
This is not your homework, isn't it ? :)