import data from an Excel sheet to the database

[JoshT]

There's two ways I know of:

1. Set a reference to Excel's Object library, then you can automate it - Dim x as Excel.Application, etc.

2. There's an driver or provider you can use with ADO like the spreadsheet was a database.