Ramonicto

You provide very lite information about the texfiles and how your VB program works.

But if you like to use VB use it.

I use VB6 and now VB2008.net and ADO.net to import textfiles.

This is a very short description.

The textfiles are imported with bulk insert to a staging table form which I use substring formulas to

extrakt the different fields in the textfile to a temporary table. From that table you can check if rows already exists in the "main" table and avoid to import them.

I have a SQL Server 2008 64 bit and the procedure is very fast and stable and

is scheduled to run every day.

/Gosta