Here is what is going on. We have a system on one machine in which several ASCII files are downloaded nightly. At the time of this writing, I upload the ASCII files into foxpro data tables so other systems/reports/queries/ etc. can run in which the source server cannot produce.

We are switching to VB.NET with SQL Server as our DataBase. All data conversion takes place at night unattended. Two examples of the data manipulation is as follows:

1. Date fields. The source file uses a number that has to be converted to a true Date Value. 1 = 01/01/1968, 2 = 01/02/1968, etc.

3. Numeric Fields. The source file leaves out all decimal points. Some numbers must be divided by 10, some 100, all the way up to 100000000.

My current Foxpro application runs very fast. Converting the data using VB.NET posting to SQL server has been disappointingly slow. So, I'm looking for some sample code that has proven to be very fast when posting data.

Thanks for any code suggestions.