karthi (2/25/2008)
Hi,I have a flat file without delimiters. The format is like
L10123444 221
but Col1 = L;col2=1;col3=0123444 etc...
how to import this kind of flat file
Thanks in advance
All of the methods suggested, so far, are good and will do.
If you want absolute blinding speed, though, using Bulk Insert with a BCP format file will out perform just about anything else you can do. The information for a BCP format file is in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.