I was thinking of looking into DTS - especially for the clients that have SQL Server - but I don't think that DTS is an alternative with MSDE - I'll have to do some more investigating.


>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