Hi, <BR> I have a question about SQL statement in ASP:<BR> I want to creat a new table from the existing table, then I type this:<BR> 669 NewTable = "create TABLE td_tablec as select * FROM td_num"<BR> 670 Set opentesttable = promsDB.Execute(NewTable)<BR> However, it return this error:<BR> Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR><BR> [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement. <BR>/proms/listpage.asp, line 670 <BR> If you know the answer, could you tell me?<BR><BR>Thanks<BR>James<BR>