(Assuming SQL Server 2005) - Have you considered using SQL Server itself by
using a SQL Server Integration Services package. I suggest you check it out
- it does the job you want with very little effort and virtually no
programming. It can be called from a .NET program if needed - see material
and examples on using the Service Broker in SQL Server 2005 to send a message
and run the package with the proper privileges from the auto-response stored
procedure by using the EXECUTE AS directive in the message queue set up.

"dclements" wrote:

I've been assigned a task to write an Visual Basic .Net application that
read data from an existing excel file and uploads the data to an SQL Server.
The excel file itself is not a VSTO application, nor does it use VBA code.

I know I can save an Excel file as a tab delimited file, import that file
into an access database, and then use the data in the access database updata
the file, but this is not an an acceptable solution.

Does anyone know of a way to read data from a plain excel spreadsheet
intoVB program? I imagine this is a simple process, but I have not found any
example that does this.