title: MS Access create table from query c#
body: <p>Unable to create table via </p>
  
  <pre><code>CREATE TABLE AAA ( 
                 [Percentage] Number(15),
                 [ID] AutoIncrement CONSTRAINT PRIMARY KEY ,
                 [CaseRecNo] Number(15),
                 [CaseName] Text,
                 [Amount] Currency 
               )
  </code></pre>
  
  <p>Gives Syntax Error, </p>
  
  <p>How to set Number filed type double ?</p>