I would look into using DTS, it's optimized for high speed data loads and supports things like transformation and lookups.

Roman


>Hi,
>
>I have to come up with a solution that will be responsible for moving between 250,000 to over 10,000,000 records from a VFP table into a table in a SQL Server Database (or MSDE for the clients with lower volumes).
>
>My initial thought was to write a little VB program to bring in about 1,000 records at a time, transform the data into the correct format, and insert into SQL Server using Bulk Insert - and keep repeating the process until all the records have been imported.
>
>Has anyone else had to do something similiar? If so, I'd be interested in hearing about the approach that you used.
>
>Regards,
>
>Al