Originally posted by: Menei
URGENT!!!
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?
Thanks.
Reply
Originally posted by: Martin Adamski
I have a problem with using Clipper database in Visual MFC
code.
Are there any classes ( or ODBC drivers) which I can use to read records from dbf file with memo fields and ntx index?
Originally posted by: NDA
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 ?!?
many thanks
Originally posted by: Jai Shah
how do i open access databases
ReplyOriginally posted by: vinay
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 vinay.d.e@usa.net
Originally posted by: jieun
Hi,
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?
thank you.
Have a nide day!!!
Originally posted by: candy
As title!
ReplyOriginally posted by: ooi
How to convert MS Word to HTML ?
Originally posted by: Juergen Lotter
Hello,
I have the problem to open an attached excel-table without
knowing the name of the table.
Is this possible and how?
Originally posted by: Rosin
When I run the code, I get an ugly error saying:
"Could not find installable ISAM"
Any idea how can I solve this?
Thanks a lot,
Rosin