*.csv

why dont you use Access to import the file

You can also make a macro in access and then use automation to start Access and run the macro!
This requires Access on the PC.

There is no Access on the PC, and I really have to do it in VB :()

This is an example of automating Access

Sub CommandButton1_Click()
' This procedure is a brief sample showing
' how to automate Access
Dim appAccess as object

  ' Get a reference to the Access Application object.
  Set appAccess = CreateObject("Access.Application")
 
  ' Open the Northwind database.
  ' Modify the path as needed.
  appAccess.OpenCurrentDatabase "nwind.mdb"

  ' Run a macro
  appAccess.DoCmd.RunMacro "Print Sales"

  ' Display the application.
  appAccess.Visible = TRUE


  ' Close the database.
  appAccess.CloseCurrentDatabase

  ' Quit Access.
  appAccess.Quit

  ' Close the object variable.
  Set appAccess = Nothing

End Sub

Har du en access database i forvejen? Eller skal du via VB lave en helt ny??

Jeg har en i forvejen