ms-access API

[angel]

Hi everybody!
I’m looking for ms-access API help and/or documentation. I’m writing a
PowerBuilder application where I have to import/export data from/to
ms-access to/from another data source.
Could anybody of you tell me where I should start?
Thanks.
Angel

 

[John Nurick]

Hi Angel,

I've never used PowerBuilder but probably you can just use ODBC to
connect to the Access database (.mdb file) without using Access itself
at all.

Otherwise, if PowerBuilder is OLE-compatible, you can use the DAO or
ADODB object models to open the .mdb and manipulate the data using
queries or recordset operations. (Access itself exposes an object model
but it's seldom necessary or appropriate to use this for simple
importing/exporting.)