MS Access Database using ABAP Program

[Former Member]

Hi,

I have Requirement to Access Data from MS Access Database using ABAP Program, Please Help me if anyone is having any code or procedure .

Thanks in Advance.

Chittya Bej

[Former Member]

Hi,

Refer to this link [Upload data from MS Access tables, to SAP tables|]

[Former Member]

hi,

Use FM "ALSM_EXCEL_TO_INTERNAL_TABLE" to upload excel file into internal table .

thanq.

rajesh.k

[awin_prabhu]

Hi friend,

Just use GUI_UPLOAD function for uploading data from MS-Access to internal table.

ex:

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'C:\Testing.mdb'

filetype = 'ASC'

has_field_separator = 'X'

TABLES

data_tab = g_t_mara.

OR

Use T-code CG3Z uploading data to application server.

Note: Always give file extension as .mdb (microsoft Access)

[Former Member]

Hi ,

You can use open SQL statement to fetch records from MS Access Database from your program because open SQL is database independent , i.e -

DATA : itab like table of ms_access_tab_name.

SELECT * FROM ms_access_tab_name into table itab.

Regards

Pinaki Mukherjee

[Former Member]

Hi Chittya Bej ,

There is one ABAP program called 'RIACCESS' which can get the data from MS ACCESS into your table .Just check out this program in your ABAP editor.It will helpful to you.

Thanks

Kiran

[Former Member]

hi chittya,

U can directly upload the database file with the function module GUI_UPLOAD into an internal table

and then work with the records of the internal table.

Thanks

Ravi Aswani