L
Lena
Hi Everyone,
I tried posting this question on
microsoft.public.vc.database but got no response, perhaps
this problem is better suited for this forum.
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!!
error message:
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.
ps. sorry if this gets posted twice, the message doesnt
seem to be uploading to the newsgroup
I tried posting this question on
microsoft.public.vc.database but got no response, perhaps
this problem is better suited for this forum.
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!!
error message:
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.
ps. sorry if this gets posted twice, the message doesnt
seem to be uploading to the newsgroup