title: How can I import a tab delimited text file with Import-CSV when the file has no header row?
body: <p>I have a huge text file (around 500 MB) that is tab delimited. It doesn't contain headers. So it looks like:</p>
  
  <pre><code>20140711   IBM   29.9068    tom.smith@ibm.com    this is interesting
  20140712   HP   2.3000    tom.smith@ibm.com    this is interesting
  20140713   GOOGLE   44.9033    tom.smith@ibm.com    this is interesting
  20140714   HTC   739.70    tom.smith@ibm.com    this is interesting
  20140715   SAMSUNG   8.442    tom.smith@ibm.com    this is interesting
  20140716   MICROSOFT   67.104    tom.smith@ibm.com    this is interesting
  20140717   DELL   5.0823    tom.smith@ibm.com    this is interesting
  ...
  ...
  ...
  </code></pre>
  
  <p>I need to use Powershell to load the text into the SQL Server database as a table. As there is no headers in the text file, the "Import-Csv" cmdlet output the content incorrectly. I think it always treats the first line as headers.</p>
  
  <p>How can "Import-Csv" output whatever in the text file and forget about header config?</p>
  
  <p>Thanks.</p>