Retrieving Excel data
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.
|