problem loading data from excel into listview control 
Author Message
 problem loading data from excel into listview control

Hi Everyone,

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

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?

Also my eventual goal is to have a data loaded from an
excel spreadsheet into a listview/datagrid control. I want
to be able to edit/delete/add data and have it reflected
back in the excel spreadsheet. At the same time I want be
able to change whole columns in the display control by
loading data from an entirely different database
(afterwhich the changes would reflect in the excel file)
Does anyone know if this is possible and if so, what is
the best control and data connection to use (lisview or MS
data grid; dao, odbc, ole?)

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

Sun, 25 Dec 2005 22:32:38 GMT  
 [ 1 post ] 

 Relevant Pages 

1. problem loading excel data

2. How export listview-data to ms access or ms excel

3. Listview Control not showing some column data

4. Listview Control not showing some column data

5. Retrieving data from an MFC listview control

6. Loading just the data visible in a List control

7. How to load control persistent data?

8. Access problem with Excel data

9. Rich Edit Control Question (Loading Data)

10. Problems with COM-interface while writing data to Excel 97

11. Problem loading XML document with binary data

12. Loading massive data from text file to Access Database .MDB (time problem)


Powered by phpBB® Forum Software