problem loading data from excel to vc++ control
I am trying to query an excel file from visual c++ and display it's contents on a listview control. I have found that if I first create the excel file in visual c++ and then try to open the file and display contents, everything works well. However if I try to open a file that I have not initially created through vc++, then I get an error saying the table in the file I requested could not be found.
That is in case one, I create a table in a excel file called "test" and then I query table "test". In the second case I assume the table name is "sheet1" and my query fails. My question is if an excel file is treated as a database then where are the table names defined? And if table names are indeed synonymous to Worksheets in Excel, do you know what else could be causing the problem?
Thanks in Advance!!
Microsoft Jet database engine could not find the object 'mytablename'. Make sure the object exists and that you spell its name and path name correctly.