thermanson (12/16/2008)
I have found that TAB seperated files seem to cause the least number of problems. Unfortunately TABs aren't always possible, if you have to work with a file created by a mainframe or a file that you receive by FTP then TABs probably aren't an option.It is possible to Bulk Insert a file starting at the "nth" row with out creating a format file. Simply use the firstrow option.
Bulk Insert #temp
From 'c:\data.txt'
With (firstrow = 2)
Thanks for the tip about about firstrow. Unfortunatley the built in Powershell cmdlet, Export-CSV only supports a comma as a separator.