Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | chander_2580Yak Posting Veteran
 
 
                                        76 Posts | 
                                            
                                            |  Posted - 2008-04-23 : 11:52:37 
 |  
                                            | Hi GurusI am importing data from flat text file into sqlserver 2000 table, while importing data .. i m facing the below mentioned error"Too many columns found in the current row;non-whitespace charater were found after the last defined column's data"please help me out of this error.thanks chander |  |  
                                    | sodeepMaster Smack Fu Yak Hacker
 
 
                                    7174 Posts | 
                                        
                                          |  Posted - 2008-04-23 : 13:22:14 
 |  
                                          | check this out:http://support.microsoft.com/kb/300042 |  
                                          |  |  |  
                                |  |  |  |