Ah! my bad. sorry

It is the "For each $row... Next"-part that is slow.

The Loadfile that I use looks like this:
 Code:
Function loadfile($file)
  DIM $fso,$f,$fs

  $fso = CreateObject("Scripting.FileSystemObject")
	$f = $fso.GetFile($file)
	If @ERROR
    Exit(2)
  EndIf

  $fs = $f.OpenAsTextStream(1)
  $loadfile = Split($fs.Read($f.size),@CRLF)

  Exit(@ERROR)
EndFunction


The output looks something like this:

[1] : 02:31:04
[2] : 02:31:11
[3] : 02:31:11
[4] : 02:43:08

[3] to [4] takes 12 mins.
(I have removed some data from the csv)

The thing is that in the same time as this script go from [1] to [3], Access has imported everything.

That's why I wonder if the "SELECT * INTO"-approach would be faster.


/Viggen