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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Errro while import from text file

Author  Topic 

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2008-04-23 : 11:52:37
Hi Gurus

I 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

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-23 : 13:22:14
check this out:

http://support.microsoft.com/kb/300042
Go to Top of Page
   

- Advertisement -