>>I have to update a table in SQL Server each week, and I've been doing it with a manual process until now. Does someone have a sql script for updating fairly large tables?
>
>You really need to expound on that so we know what you need to do and what you are currently doing..

I was afraid you were going to say that. Right now, I pull local motor vehicle data from the mainframe, massage it in vfp, then craete a csv file that gets imported into SQL manually. I'd like to automate it. I thought about using a remote view, but that would take a long time, I think. Is that enough info?