<div>
<div class="content wysiwyg-content">
I have a csv that I cannot begin to work with. &nbsp;I would like to put it in sql and work with it but am open to suggestions.<br />
I have access to sql 2012 standard and excel 2013 and access but both office apps crash when trying to open it.<br />
<br />
problem is...<br />
I can't even remotely get started working with this file to start working with the data.<br />
<br />
I know the first couple of rows is garbage information<br />
<br />
after that, I have no idea how many rows or how many columns there are.<br />
<br />
any ideas.
</div>
</div>


I have a csv that I cannot begin to work with.  I would like to put it in sql and work with it but am open to suggestions.
I have access to sql 2012 standard and excel 2013 and access but both office apps crash when trying to open it.

problem is...
I can't even remotely get started working with this file to start working with the data.

I know the first couple of rows is garbage information

after that, I have no idea how many rows or how many columns there are.

any ideas.

trying to work with enormous csv file

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.