The fastest way to import over 2000 csv files (1 Viewer)

[Guus2005]

Thanks for all the responses.

I tried both solutions. With Importspecification (sql INSERT statement) and using the FileSystemObject (Open Filename For Input)

I made an import specification and used the SQL Insert statement using the import specification and imported 10 files with a total of approx 70k records.
Then i used the solution with the FileSystemObject on the same files.

It turns out that importing the records using the import specification is a lot faster (3sec) than using the FSO (29sec)

I have almost 9 milion records to import so i probably use the import specification.

Thanks again!