SQL Server Bulk import data from .csv into new table
<p>I can't seem to find the answer to this quite trivial question.</p>

<p>I would like to bulk import data from a <code>.csv</code> file (with an unknown number of columns, comma separated) file to a new SQL Server table, within an existing database. The <code>BULK INSERT</code> statement works fine if the table is predefined, but since I don't know the number of columns of the <code>.csv</code> file upfront, this won't work.</p>

<p>I was trying to use bulk in combination with openrowset, but can't get it working.</p>

<p>By the way: SSIS won't be an option in this case, since I would like to incorporate the query within R (sqlquery) or Python.</p>

<p>Help would be highly appreciated!</p>