I like x64 bit. No switches needed. Don't know if your server is capable, but might be an option.

GE

Tony -

Verify if the firewall is on or off. Then test with it off.

There's also a log file for this, which may be helpful.

How you are connecting?

Thanks, GE

Scroll down this page and see if this is what you're looking for.

http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

Microsoft OLEDB Provider for DB2

The Microsoft OLE DB Provider for DB2 is a COM component for...

If you use the temporary table to delete existing, then do an insert, you should be able to avoid row by row logic.

If something is deleted out of the Excel...

I'm not much of a programmer, but I'd make sure you are closing your connections. I assume you're runnning SQL on the machine you're rebooting.

I few more details - like...

Francis -

Try creating a linked server.

If the data is important enough to be used in SQL server, I'd consider getting it moved into SQL for the back end. You could...