>Bob, did you find a good way to update your server with many records. I thought of adding data to a parameterized remote view then doing a tableupdate(). I would set the view for tablebuffering instead of rowbuffering. Also the reason to use the parameterized remote view would be so that I wouldn't have any data coming back my way. > >If you find a better idea I would like to hear it. The fastest method is using MS SQL Server's BCP program.