ms-access API

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)
 
Back
Top