Re: Accessing many type of DB
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Wed, 26 Apr 2006 12:32:11 +0100
I have to develop an application which can access any type of database,2005,
selected by the user; specially Excel files, Txt, csv, XML, and may be
connection to a DB via odbc, ...
I need help about the technologie to use to do this; I have visual C++
and I want this to work on windows 2000 and later
You can do all of that with ADO.
1) The Jet 4.0 provider can be used to read/write to Excel.
You now need to download that separately from MDAC
2) The Jet 4.0 provider can also be used to to write to text files,
including CSV text files
3) You can write out Recordsets in XML format
4) And there is a legacy provider that can connect to ODBC so that ADO
objects can be used.
You now need to download that separately from MDAC
It is all possible. You need to write the code.
Stephen Howe
.
- References:
- Accessing many type of DB
- From: visualcpp
- Accessing many type of DB
- Prev by Date: Re: How to update parent-child tables
- Next by Date: Re: how to retrieve [RecordsAffected] count from cmd.Excecute in V
- Previous by thread: Accessing many type of DB
- Next by thread: filtering detail table
- Index(es):
Relevant Pages
|
|
