if you use char datatype in Access, when the data lenth less then the column length,Access will use space to fill it.so if your data length is not same,please use varchar in Access.
you must read some document to understand what is the char and what is the varchar.you can use the varchar(N) datatype in create table sql statement in Access.
you must read some document to understand what is the char and what is the varchar.you can use the varchar(N) datatype in create table sql statement in Access to create table. the N is the column max size.eg. create table tablename ( id counter not null, column1 varchar(100) not null )
ACCESS中用SQL语句不能设置默认值!
create table tablename (
id counter not null,
column1 varchar(100) not null
)