I'm using ado to join data in excel. but when i run my application i have a message box which appears where it's written the following message:"database erroritem cannot be found in the collection corresponding to the requested name or ordinal". I use the jet oledb 4.0 to find my filename:"provider=microsoft.jet.OLEDB.4.0;Data Source=%s;Extended Properties=Excel 8.0;","test.xls" and after to find the table name: table_name=pRstSchema->Fields->GetItem("TABLE_NAME"
->Value;(where pRstSchema is a _RecordsetPtr smart pointer.
The TABLE_NAME is simply selected cells (A1:B10) I have called like that with the small edit box on the left top of the excel worksheet!
If someone could tell me why it doesn't work...
Gerald
->Value;(where pRstSchema is a _RecordsetPtr smart pointer.The TABLE_NAME is simply selected cells (A1:B10) I have called like that with the small edit box on the left top of the excel worksheet!
If someone could tell me why it doesn't work...
Gerald