Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Chad Miller Loading Data With Powershell RE: Loading Data With Powershell

  • December 16, 2008 at 11:03 am

    #913342

    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.