Download data to MS access 97/2000 

Is there any way to download data to MS access?

Please use the standard ABAP program "RIACCESS".

Before using the program "RIACCESS", you need to install the PS utilities, which are part of SAPGUI install CD.

It is available in the "\SAPGUI\PS directory". 

Then do the followings :

1. Select transaction code SALE -> Systems in network-> Define RFC Destination. 

2. You will need two RFC destinations (TCP/IP connections for the front-end workstation). 
     Setup the two RFC destinations PS_ACCESS_1 and PS_ACCESS_2 and you'll have to get them to point to 
     wdpsastr.exe and wdpsatab.exe respectively. 

3. Then execute RIACCESS and choose PS_ACCESS_1 to generate access tables. 

The system must also be able to access the RFC-DLL files (librfc2.dll, librfc3.dll, librfc4.dll, librfc5.dll, librfc6.dll, vrfc.dll). 

Please note that Access only supports tables with up to 255 fields. 

Questions
Do you have a ABAP Question?

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.