Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with tables in excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with pivot tables | Excel Worksheet Functions | |||
Pivot tables problem | Excel Discussion (Misc queries) | |||
Localisation problem with pivot tables | Setting up and Configuration of Excel | |||
fortnightly payments problem in Excel Amortization tables? | Excel Discussion (Misc queries) | |||
Please help: Pivot Tables problem | Excel Discussion (Misc queries) |