Import from / Export to MS Access 97/2000/2003

[Former Member]

Hi everyone,

How can I import master data from and export master data to MS Access? I could not find anything on that topic in this forum.

- I read somewhere that export to Access 2003 can be easily done. But how? How about import from?

- I might also need to import from/export to MS Access 97 and 2000. What are my options here? Do I have to work with CSV files or can I connect directly?

Best regards, Daniel

[Former Member · Accepted solution]

Hi Daniel,

1] To Export Data into MS Access follow the link.[MDM DATA MANAGER]

[http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0677c82b40a2ee10000000a11466f/frameset.htm]

and refer to "Exporting Records" Option.

2] To Import Data from MS Access: (MDM IMPORT MANAGER)

[http://help.sap.com/saphelp_mdm550/helpdata/en/43/12036df94c3e92e10000000a1553f6/frameset.htm]

refer to : "Guided Tour"->"Strating and exiting Import Manager"->"Source Properties" Section.

You should be able to find answer for your options for MS ACCESS 97 and 2000.

Import manager allows us to directly connect to MS ACCESS and CSV files as well.

Regards.

Amol.

[Former Member · Accepted solution]

Hi Amol,

thanks a lot! Your answer pretty much solved much question.

Best regards, Daniel