Read csv file in vb 6.0

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. I use Access as my DB. I am not sure whether you will know the fields in advance.

I will assume that you don't know until the file is opened. Also, I am assuming you are using ADO. Access already supports importing records from CSV files, so this can be done quite easily by launching and controlling an instance of Access.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 7 years, 9 months ago. Active yesterday. In cases when you want to read specific lines from a text file you can adapt the line by line read code as below. It allows you to read a certain number of lines noLines from a text file from a specific start line number sLine.

If you set noLines to 0 it will read all lines till end of the file. With Binary files often you will be using objects which are not of fixed byte length like Integers. For example you would want to read Strings from binary files together with other data types. In such cases use the Type object data type when writing to a file.

Learn more here. Reply to this Topic. This topic is old! No one has contributed to this discussion in over 8 years. Are you sure you have something valuable to add to revive the existing conversation?

Consider starting a new topic instead. Otherwise, please be thoughtful, detailed and courteous, and adhere to our posting rules. Edit Preview.