I can't seem to find the answer to this quite trivial question.

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

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

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.

Help would be highly appreciated!