Click here to Skip to main content
15,894,825 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Problem while data insertion in Access - Plz need help Pin
Jats_4ru29-Apr-07 21:08
Jats_4ru29-Apr-07 21:08 
GeneralRe: Problem while data insertion in Access - Plz need help Pin
Colin Angus Mackay30-Apr-07 5:24
Colin Angus Mackay30-Apr-07 5:24 
QuestionHow to read volume label Pin
re infecta29-Apr-07 19:24
re infecta29-Apr-07 19:24 
AnswerRe: How to read volume label Pin
A*****29-Apr-07 19:42
A*****29-Apr-07 19:42 
QuestionRunning a function every hour Pin
re infecta29-Apr-07 19:22
re infecta29-Apr-07 19:22 
AnswerRe: Running a function every hour Pin
Dave Kreskowiak30-Apr-07 8:09
mveDave Kreskowiak30-Apr-07 8:09 
Questioncsv file reading Problem Pin
virendra_00729-Apr-07 19:08
virendra_00729-Apr-07 19:08 
AnswerRe: csv file reading Problem Pin
Dave Kreskowiak30-Apr-07 8:08
mveDave Kreskowiak30-Apr-07 8:08 
virendra_007 wrote:
Though code is going fine with text files.


A CSV file IS a text file. All CSV stands for is Comma Seperated Values.

virendra_007 wrote:
whole_file = Input$(LOF(fnum), #fnum)


This is not a good method, as you've found out. Read each line from the file as a text line and process it, one line at a time:
Dim TextLine
Open "MyFile.CSV" For Input As #1
Do While Not EOF(1)
   Line Input #1, TextLine
   ' parse up the line on comma's to get the values
Loop
Close #1



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007


GeneralRe: csv file reading Problem Pin
virendra_0071-May-07 23:51
virendra_0071-May-07 23:51 
Questioncombo box Pin
Patelgarha29-Apr-07 18:50
Patelgarha29-Apr-07 18:50 
AnswerRe: combo box Pin
Christian Graus29-Apr-07 18:57
protectorChristian Graus29-Apr-07 18:57 
AnswerRe: combo box Pin
Sonia Gupta29-Apr-07 19:29
Sonia Gupta29-Apr-07 19:29 
QuestionEmbedding Javascript in ASP Pin
jase7629-Apr-07 18:11
jase7629-Apr-07 18:11 
AnswerRe: Embedding Javascript in ASP Pin
Christian Graus29-Apr-07 18:21
protectorChristian Graus29-Apr-07 18:21 
GeneralRe: Embedding Javascript in ASP Pin
jase7629-Apr-07 20:27
jase7629-Apr-07 20:27 
QuestionHOw to use Shared Event Handler? Pin
braleping29-Apr-07 16:26
braleping29-Apr-07 16:26 
Questionhow to use Share Event Handler? Pin
braleping29-Apr-07 16:10
braleping29-Apr-07 16:10 
Questionstring manipulation Pin
uglyeyes29-Apr-07 13:44
uglyeyes29-Apr-07 13:44 
AnswerRe: string manipulation Pin
Colin Angus Mackay29-Apr-07 14:13
Colin Angus Mackay29-Apr-07 14:13 
AnswerRe: string manipulation Pin
Christian Graus29-Apr-07 14:53
protectorChristian Graus29-Apr-07 14:53 
GeneralRe: string manipulation Pin
uglyeyes29-Apr-07 16:10
uglyeyes29-Apr-07 16:10 
GeneralRe: string manipulation Pin
Christian Graus29-Apr-07 17:28
protectorChristian Graus29-Apr-07 17:28 
AnswerRe: string manipulation Pin
Arun.Immanuel29-Apr-07 16:37
Arun.Immanuel29-Apr-07 16:37 
GeneralRe: string manipulation Pin
uglyeyes29-Apr-07 17:29
uglyeyes29-Apr-07 17:29 
GeneralRe: string manipulation Pin
Arun.Immanuel29-Apr-07 18:14
Arun.Immanuel29-Apr-07 18:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.