SQL over the Net

[hellilyntax]

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?

[alex_read]

You're going to use a huge amount of bandwidth & potentially cripple your Internet connection like that

Try uploading the Excel file first (if the file is possiby going to be larger than 4mb in size, please post back as you will need to add a setting to allow this).

Once the file is on your server you have several options to load the data into your database -v if you are using SQL Server as your database, look into "DTS" to let SQL Server upload the data for you, otherwise I would look at writing a Windows NT service to poll intermittantly, pickup any new Excel files which have been uploaded, then passing the row information to a stored procedure (if using Oracle) or generating the SQL SELECT statements as you were thinking.

[hellilyntax]

thanks alex,
me either think to upload the excel file first..but at client side, ftp isn't allowed by administrator. i tried to look on http binary upload and didnt found any codes that simply works, even here....
i also think about DTS but fyi, my SQL server is at Hosting company and i have little access on that server. it is shared server. maybe too much red tape there.

i never done such application like this before...too many restriction and integration....
i tried to be transparent without third party involvement...could it possible?