hi guys,
before i come to my problem, ill let you know my app architecture.
i have a vb program to update my sql server database which is located at hosting company.
the program will transfer every rows in Excel on local pc to MSSQL table on server.

the problem is, it takes too long to complete the transaction because it involves thousands of rows (up to 10000). when i try, it only can execute 800 rows and the connection will break.

do you have any idea to overcome this...
is there anything to do with
1. connection speed
2. sql statement
3. architecture itself
4. is it possible to execute 10000 rows over the net?
5. do i have to have the SQL Server on local so that the journey can be faster?

please give me some idea....