[thelist] asp.net: Query an Excel spreadsheet

Casey aspnet at thecrookstons.com
Thu Dec 1 16:49:51 CST 2005


I've got this all worked out but the actual query:

Select * from Sheet1

I'm told:

The Microsoft Jet database engine could not find the object 'data1'. Make 
sure the object exists and that you spell its name and the path name 
correctly.

I have not changed the name of the sheet, which is the default "Sheet1".  Is 
there some other name that I should be calling it?

I'm using this as my source: (found with Google)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q311731

Thanks!




More information about the thelist mailing list