topic MS Access Database using ABAP Program in Application Development and Automation Discussions

MS Access Database using ABAP Program

Former Member — Wed, 21 Jan 2009 07:13:15 GMT

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

Re: MS Access Database using ABAP Program

Former Member — Wed, 21 Jan 2009 07:44:44 GMT

Hi,

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

Re: MS Access Database using ABAP Program

Former Member — Wed, 21 Jan 2009 10:00:03 GMT

hi,

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

thanq.

rajesh.k

Re: MS Access Database using ABAP Program

awin_prabhu — Wed, 04 Feb 2009 09:03:42 GMT

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.

Use T-code CG3Z uploading data to application server.

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

Re: MS Access Database using ABAP Program

Former Member — Wed, 04 Feb 2009 09:20:42 GMT

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

Re: MS Access Database using ABAP Program

Former Member — Wed, 04 Feb 2009 09:23:29 GMT

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

Re: MS Access Database using ABAP Program

Former Member — Wed, 04 Feb 2009 10:54:18 GMT

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