>My reason at the moment is that I only solved this last night (after about two weeks of testing different approaches and very late nights). My reason for possibly keeping this option is that with a remote stored procedure, I may be able to 'fire and forget' to finish the processing off. This may not be so.
>

I see...

>about eight million rows. If I can get SQL Server to do most of the work it >should be faster!

Agreed... question... is it not possible to get whatever is generating this data to put it directly into the SQL table, either the temp one of the live one?

If not, could you have a VFP app, the constantly runs and moniors a directory for data being placed in it, then, when it is, it will be added to the server?
>

>I'm doing this at home so I can check it in the morning before I leave for work and try different things at my leisure!

Got ya... sounds like an interesting project. I have never had to deal with so much data in any of my projects.

BOb