hi guys,
i've posted about this topic many times and didnt find solution yet...
i hope somebody can help me on this matter this time...
before i come to my problem,here is description of my project architecture...

Description
i create a vb program to generate multiple excel 8.0 file from production machine on my side. i have to update all rows in the excel to my online databse MSSQL Server at hosting company.

System Design
i schedule the update to be run daily erly morning.
the vb program will execute SELECT for every rows in excel and do INSERT in SQL Database over the net.

Problem
1. the rows is up to 10000 rows (is it possible to execute over the net?)
2. i done the test and the connection always timed out (first few rows, it execute about 1 row per second, then will slow down little bit until break). i alreadt set commadtimeout to 3000....
3. no encryption is applied

Im wondering where is the fault...
1. is there something to do with speed connection
2. should i upload the excel file to server first then execute using HTTP.which one is faster?update from client using VB or update at server using Web?