Thread: Bulk Insert
View Single Post
  #7 (permalink)  
Old December 11th, 2007, 05:45 PM
snufse snufse is offline
Friend of Wrox
Points: 923, Level: 11
Points: 923, Level: 11 Points: 923, Level: 11 Points: 923, Level: 11
Activity: 5%
Activity: 5% Activity: 5% Activity: 5%
 
Join Date: Mar 2007
Location: West Palm Beach, Florida, USA.
Posts: 198
Thanks: 4
Thanked 0 Times in 0 Posts
Default
Scott:
Using your first example it created this (using 1 data element). I just have 3 records in the text file so why did it code insert a "Null" in line 4 and 5"?

JohnGreed
KevinHeath
TimBarker
NULL
NULL

After this I tried with 2 fields and field terminator = ' ', gives me the same error, for some reason it does not like fieldterminators......
Reply With Quote