Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to upload data from MS Access file to an Internal table

Former Member
0 Kudos

Hi,

I need to upload data from a table of MS Access ( .mdb file ) to an internal table.

Please help.

Regards,

5 REPLIES 5

Former Member
0 Kudos

hi Ramana

you can try the following FM's

MSACCESS_STRUCT_EXPORT_RFC

POPUP_FOR_DEST_AND_DBNAME

PS_MATERIAL_RUE_VIA_ACCESS

PS_MATMELDUNGEN_MSACCESS

PS_ZEITRUECKMELDUNGEN_MSACCESS

STRUCTURE_EXPORT_TO_MSACCESS

TABLE_CONVERT_FOR_MSACCESS

TABLE_EXPORT_TO_MSACCESS

TABLE_EXPORT_TO_MSACCESS_RFC

TABLE_EXPORT_TO_MSACCESS_RFCFE

hope it helps

regards

Aakash Banga

0 Kudos

Hi Akash there is same requirement of which i need to download the MDB file from sap to SQL server .Do u know how is that?

Regards

Sas

0 Kudos

But I need to import data from Access not Export

Former Member
0 Kudos

hi ramana,

i am not sure , but try this

u save the access content as .txt file

and use the FM - GUI_upload.

This will upload the data in ur internal table.

hope it works

thanks

Sachin

0 Kudos

Hi,

Thanks Sachin,

Already we have a VB application to convert into .txt file and then upload to SAP.

But now we need to eliminate this process by directly uploading form .mdb.

Regards,