Create a table in Access

/* CString m_createtable;
M_createtable = "create table JBK_750 (No. autoincrement not null, sequence number varchar (20) primary key,
Body number varchar (50), inner board number varchar (50), In-host function varchar (50 ),
Production Time varchar (50), recipient varchar (50), check time varchar (50 ),
Warehouse receiving time: varchar (50); warehouse Picking Time: varchar (50); Shipping Company: varchar (50 ),
Remarks: varchar (50), purchase board date: varchar (50), reviewer: varchar (50 ),
Supply Organization varchar (50), application code unit varchar (50), expiration date varchar (50 ),
Applicant varchar (50), sales company varchar (50), user varchar (50 ),
The billing date is varchar (50), varchar (50), and varchar (50 ),
Function varchar (50), registration number varchar (50), registration time varchar (50 ),
String 1 varchar (50), string 2 varchar (50), string 3 varchar (50), string 4 varchar (50 ),
String 5 varchar (50), string 6 varchar (50), string 7 varchar (50), string 8 varchar (50 ),
String 9 varchar (50 ),
String 10 varchar (50 ))";
M_db.ExecuteSQL (m_createtable );
*/


CString m_createtable;
M_createtable.Format ("create table ZCM_750 (No. autoincrement not null,
Sequential Number varchar (50 ),
Host No. varchar (50 ),
String No. varchar (50 ),
Function No. varchar (50 ),
Function Description varchar (50 ),
Application Unit int,
User unit varchar (50 ),
Applicant varchar (50 ),
Coded date int,
Date of shipment int,
Check varchar (5 ),
Whether varchar (5) has been shipped ),
Whether to account varchar (5 ),
Permanent code varchar (5 ),
Control Code varchar (5 ),
Temporary Control Code int,
Maximum temporary code time int,
Operation description varchar (50 ),
Operation Date int )");
M_db.ExecuteSQL (m_createtable );

CString SQL;

SQL. Format ("insert into ZCM_750 (sequence number, host number,
String number, function number, function description, applicant, user, applicant,
Date of completion, date of delivery, check, shipment, and receipt,
Permanent code, control code, temporary control code, maximum temporary code time,
Operation description, Operation Date) select sequence number, machine number, string number,
Function number, function description, applicant, user, applicant, date of code done,
Date of delivery, check, shipment, account receipt, permanent code, control code,
Temporary Control Code, maximum temporary code time, operation description, operation date from registration code management
Where sequential number = '% S' "," 109790000997 ");
M_db.ExecuteSQL (SQL );