i am trying your way, but i am having a little difficulty.

I am trying to load an excel spreadsheet into a dataset and I keep getting the error database or object is readonly. The spreadsheet is not your typical database layout, so i don't know if that has anything to do with it or not. below is my basics. thanks for the help.

sConnStr = "provider=Microsoft.Jet.OLEDB.4.0; " & _
                                        "data source=" & strDatabase & "; " & _
                                        "Extended Properties=""Excel 8.0;HDR=NO;ReadOnly=False;"""

OpenConnection() ' works great
CreateAdapter()  ' works great
CreateDataSet()  ' works great
DataAdapter.Fill(DataSetObject, DataTableName)  ' error
CloseConnection() ' works great