I across a problem. I have a excel 97 file which contain
mixed type cell in it. For example, in a column I
call it Field("test"). It has int type value cell or string
type value cell or date type value cell and so on in this column called Field("test").
After I opened thie Excel 97 file through CDaoDatabase and CDaoRecordset, I try to get a cell value by
GetFieldValue(fieldname,&variant). But my program
terminates now and a dialog displayed which said "Runtime
error. Application terminated"
Can I read mixed type cell in Excel 97 through DAO?
My problem is:
.) Given 2 distinct source table in dbf format, create a target one, in dbf format too, making some query on the sources.
This has been my approach:
1) Create a new CDaoDatabase ( say temp.mdb)
2) attach source tables into temp database
3) perform a union query to merge and fiter sources: this give me a target recordset
4) Create target.dbf from target recordset
First 3 point has success ( if i open tmp.dbf with MS Access, i can view and edit attached source tables) but i can succeed in creating a CDaoRecorset with update property on target recordset....
How can i crete target dbf... ??
Is my approch wrong ??
How perform last step ?!?
I have read the other articles about accessing databses through DAO but they seem very complicated. Is there a simpler method? microsoft recommends linking tables through access.
1)how is this done
2)is this easy :-) ?
please email me if you know at email@example.com
i am korean, and i study in pohang techonology university and I am M.S.
I am programming using the MFC to access DB.
I made a DB in ms-access2000
and then i made a new project,
When i make a new project, i select not ODBC but DAO option.
At that time, 'Unrecognized database format" message pops up.
if i select ODBC option, i don't see this messsage.
So, i wonder MS-ACCESS2000 does not support DAO option.
Do you have any idea?
Have a nide day!!!