VB School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become a VB Expert!

Join 300,461 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,667 people online right now. Registration is fast and FREE... Join Now!




Open Text file in VB6 using Row delimiter

 

Open Text file in VB6 using Row delimiter

Mohsin ad

30 Jun, 2009 - 04:16 AM
Post #1

New D.I.C Head
*

Joined: 30 Jun, 2009
Posts: 1

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....

User is offlineProfile CardPM
+Quote Post


firebolt

RE: Open Text File In VB6 Using Row Delimiter

30 Jun, 2009 - 04:22 AM
Post #2

D.I.C Lover
Group Icon

Joined: 20 Feb, 2009
Posts: 5,463



Thanked: 75 times
Dream Kudos: 1675
My Contributions
Hi.
The corner cubicle is not suppose to be for programming smile.gif Please ask programming questions in the appropriate forum, found on the eft of screen. Thanks.
User is offlineProfile CardPM
+Quote Post

vb5prgrmr

RE: Open Text File In VB6 Using Row Delimiter

30 Jun, 2009 - 09:11 PM
Post #3

D.I.C Regular
***

Joined: 21 Mar, 2009
Posts: 459



Thanked: 30 times
My Contributions
See if this can help you read chuncks in...

http://www.vbforums.com/showthread.php?t=5...ght=large+files

then split those chuncks on vbLf to put each "line" into an element of an array, then do your thing.


Good Luck


User is offlineProfile CardPM
+Quote Post

born2c0de

RE: Open Text File In VB6 Using Row Delimiter

1 Jul, 2009 - 08:59 AM
Post #4

printf("I'm a %XR",195936478);
Group Icon

Joined: 26 Nov, 2004
Posts: 4,542



Thanked: 98 times
Dream Kudos: 2825
Expert In: J2ME, 80x86 Assembly, C/C++, VB6, VB.NET, C#, J2SE, Win32 API, Reversing

My Contributions
Read this tutorial to help you out.
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/8/09 02:19AM

Live VB Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month