title: sql server 2008: is it possible to specify format instead of using formatfile?
body: <pre><code>USE AdventureWorks2008R2;
  GO
  INSERT INTO myTestSkipField 
     SELECT *
        FROM  OPENROWSET(BULK  'C:\myTestSkipField-c.dat',
        FORMATFILE='C:\myTestSkipField.fmt'  
         ) AS t1;
  GO 
  </code></pre>
  
  <p>i dont want to specify a <code>formatfile</code>!!! i just want to specify the format inline. is this possible?</p>