[QUOTE=RoninZA]Kenobewan - although DTS would be a handy way to import data from csv files into SQL, not all versions of SQL Server include DTS, such as MSDE.

82, what I would suggest is to open your file using a System.IO.Strea mReader, with reference to the path of your file. Use the StreamReader.Re adLine method to read a line from your file into a string, and parse the string using the string.Split('' ) method, to break it up into...

I have a csv file and it contains 4 columns which contain ip address of world.
example :
the colms are :
starting ip, endip, country code and country name ,
starting ip contains ip address like 200.1.3.4 same in end ip also

now the coloums in sql are
id , startip_1, startip_2...... .startip_6 , endip_1, endip_2.....end ip_6, country code, country name .

now i want to select the 1 by...