Question: i want to allow the user to upload xls file with 9 columns and unlimited number of rows.
i will run over everyline and insert the data to the db

how do i read the xls file?

Answer: 
Example of using an SQL statement to update Access from Excel.

```
Set cn = CreateObject("ADODB.Connection")

scn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\docs\dbto.mdb"

cn.Open scn

sSQL = "SELECT * INTO NewTable FROM "
sSQL = sSQL & "[Excel 8.0;HDR=YES;IMEX=2;DATABASE=C:\Docs\From.xls].[Sheet1$]"

cn.Execute sSQL, recs

MsgBox recs

```
In C#, I had to load an excel spreadsheet to a DataSet - this got me there...

[Code Project Example](http://www.codeproject.com/KB/office/ExcelToDataset.aspx)

I used Option 1 - the Preferred method! Hope this helps...

Mike