> Hello All,
> I am trying to import Unix text files into SQL Server 2005. I am having
> trouble with getting this to work:
>
> BULK INSERT MyDB.dbo.MyTable from 'c:\text.txt' WITH (fieldTERMINATOR =
> ' ',ROWTERMINATOR = '+CHAR(10)+',firstrow=6)
>
> Sample Data:
>
> ELEMENT ID                     Lay       X            Y            Z
> ------------------------------ --- ------------ ------------
> ------------
> _PT1                           217   740.000000   -79.859282
> 130.594085
> _PT2                           226   740.000000   -80.617765
> 129.797402
> _PT3                           226   740.000000   -84.037832
> 126.205085
>
> Notice the extra spaces between fields, I think that might be what is
> holding it up??