CODE
Dim sFileText As String
Dim i As Integer, R As Integer, c As Integer
Dim sFileText As String
Dim iFileNo As Integer
Dim varColumn As Variant
iFileNo = FreeFile
'open the file for reading
Open strFileName For Input As #iFileNo
Line Input #iFileNo, sFileText 'read line in a string var
Text file size is about 2 GB which i want to open, i want to open it with a row delimiter, because my machine is getting hanged when im opening it in vb6.0, i opened it in sql server 2000 it contains row delimiter {LF} where as sqlserver2k is taking {CR}{LF} by default, then later it is asking to change the row delimiter. that means the row delimiter of the txt file is not considered when it is opened. so if any body know the solution of it pls let me know....
| 
