Reading MS Access table data using OLE

stefan_kolev4 — Thu, 17 Nov 2011 10:33:32 GMT

Hi,

The purpose of the code below is to connect to MS Access DB which is located on my PC.

It is a simple mdb file w/o user name and password and only one table inside.

Everything looks simple and easy, but unfortunately I receive an error sy-subrc = 2 imediatelly after

CALL METHOD OF CONN 'Open' EXPORTING #1 = SQL.

Please advise what is wrong, why I am not able to connect to the mdb file !

Thanks in advance !

Stefan

REPORT Z_OLE.

TYPE-POOLS OLE2.

DATA: CONN TYPE OLE2_OBJECT,

RSDB TYPE OLE2_OBJECT,

SQL TYPE C LENGTH 1024.

DATA: BEGIN OF WA_TEMP,

VALUE TYPE C LENGTH 1024,

END OF WA_TEMP,

IT_TEMP LIKE STANDARD TABLE OF WA_TEMP.

DATA: BEGIN OF WA_CONTACTS,

FName(20) TYPE c ,

LNAME(20) TYPE c,

END OF WA_CONTACTS,

IT_CONTACTS LIKE TABLE OF WA_CONTACTS.

START-OF-SELECTION.

CREATE OBJECT CONN 'ADODB.Connection'.

CREATE OBJECT RSDB 'ADODB.Recordset'.

MDB Connetion infomations

CONCATENATE 'Provider=Microsoft.Jet.OLEDB.4.0;'

'Data Source=C:\HoHDB\Test.mdb;'

INTO SQL.

CALL METHOD OF CONN 'Open' EXPORTING #1 = SQL.

Query Statement ...

SQL = 'SELECT * FROM CONTACTS'.

Run Query

CALL METHOD OF RSDB 'OPEN'

EXPORTING #1 = SQL

#2 = CONN

#3 = '1'.

Re: Reading MS Access table data using OLE

stefan_kolev4 — Thu, 17 Nov 2011 11:07:21 GMT

Sorry Guys,

I've found the answer The problem was the version of the Access DB, I was using the latest version, but when I saved it as Access 2000 it works. I will do additional investigation regarding that issue.

Thanks,

Stefan

topic Re: Reading MS Access table data using OLE in Application Development and Automation Discussions

Reading MS Access table data using OLE

Re: Reading MS Access table data using OLE