Reading Tab Delimited File Using 'Input' Function

[JonnyCab]

Using VB6 Pro.

I am importing data to an Access database from a text file. How do I skip the first 4 or so lines (File Header)?.

Also using the 'Split' function to split each line into fields so I can add to appropriate field in Access table.
eg Split(expression[, delimiter[, count[, compare]]])
How to I define the delimiter as a tab?

Any help would be appreciated

Cheers

[Clunietp]

here is some ADO code that connects to a CSV file, it might make your life easier:

'Uses ADO 2.1/5

Dim cn As Connection
Dim rs As Recordset

Set cn = New Connection
Set rs = New Recordset

'open connection to folder that contains the CSV file
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\;Extended Properties=Text;"

'open the file
rs.Open "select * from test.csv", cn

'we have data
MsgBox rs.Fields(1).Value


You can use vbTab as the delimiter keyword

If you are using Input statements to read your data, you could just use 4 Line Input statements to skip the first 4 lines