title: Import from csv (into different columns) via Openrowset and Microsoft.ACE.OLEDB.12.0
body: <p>I want to clarify how I could import data from .csv into table with 3 columns (see CR Ranking.csv below). My query:</p>
  
  <pre><code> select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=C:\Work\;HDR=Yes;', 
   'SELECT * FROM [CR Ranking.csv]');
  </code></pre>
  
  <p>Outputs results into <strong>one</strong> coulmn:</p>
  
  <pre><code>header: Category;INfo;Rank
  row 1: Category 1;Info;1
  row 2: Category 2;INfo2;2
  row 3: Category 3;INfo3;3
  </code></pre>
  
  <p>IS it possible via Openrowset to split data from .csv into <strong>3</strong> columns?
  I think that I missed something from Openrowset params, perhaps it's very easy?</p>
  
  <p>And YES: i'm using 64bit ODBC drivers from Office 2010 to get drivers for .csv, .txt, etc... 
  That's why provider is: 'Microsoft.ACE.OLEDB.12.0', and that's why this conection string doesn't seem to work:</p>
  
  <pre><code>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\';Extended Properties="text; HDR=NO; FMT=Delimited";
  </code></pre>
  
  <p>CR Ranking.csv:</p>
  
  <pre><code>Category;INfo;Rank
  Category 1;Info;1
  Category 2;INfo2;2
  Category 3;Info3;3
  </code></pre>
  
  <p><strong>UPD 1:</strong>
  Is it possible to do <em>without</em> format file?</p>
  
  <p><strong>UPD 2</strong>: I made via Format file - it was easy. Sorry for disturbance.</p>