title: What's the syntax for the create table statement in Excel?
body: <p>I'm using ODBC, OLE is available if needed to dump approx 3 different types of data to different excel sheets. But to use insert statements in excel, the table has to be created first I believe, especially if the sheet doesn't exist yet.</p>
  
  <p>I used to use sql server 2000's import/export wizard that automatically generated the create table statement. </p>
  
  <p>So does anyone know the data types, and syntax for a create statement or the location of a good resource for excel sql create statements?</p>