Help - Batch Uploading from Excel spreadsheet to MS SQL Server (2005 or later)

I'm posting this question after feeling like I have literally gone to the end of the internet in search of an answer. All I have so far is partial answers without a complete solution. I'm eager to hear if anyone has a solution, and am even willing to pay for some custom development (if need be).

The problem is fairly simple: I'm looking for the fastest way to load an Excel spreadsheet to a MS SQL Server database table. I have obviously found hundreds of solutions, many of which suggest that using OPENROWSET and OPENDATASOURCE are the best technique. Other solutions suggest SQLBULKCOPY or even bcp as the fastest loading method.

The problem is that every solution I have found only seems to work if an Excel file is located on the same machine as the SQL Server database. This will not be the case, as my application will use MS Excel on a client PC to interface SQL Server on a remote server.

Again, I'm looking for the fastest solution to load a spreadsheet (potentially with 100,000 lines or more) from a local PC to a remote SQL Server database.

Please help.

Thanks,
Matt

The technique or approach that I'm looking for will require execution from the client side. In other words, users of the application will not have access to SQL Server.