PC Files for Microsoft Access

When you export and import data, SAP uses the following four Visual Basic programs:

For MS Access 7.0

for MS Access 97

Comments

wdpsastr.exe

wdpsast2.exe

wdpsas97.exe

RFC server programs that program create a Microsoft Access database with structural information provided by the ERP system.

In addition, a separate table “DDIC” is created.Do not delete or modify this table in any way as it contains structural information.

wdpsatab.exe

wdpsat97.exe

RFC server program, which fills the previously created tables with data. This program is effective only if no changes in structure occurred between the wdpsast2.exe ( wdpsas97.exe ) run and the wdpsatab.exe ( wdpsat97.exe ) run.

Caution Caution

Do not modify the structure of the Access database in any way between creating and filling in the interface tables (between calling up the wdpsastr.exe, wdpsast2.exe ( wdpsas97.exe) , and wdpsatab.exe ( wdpsat97.exe) programs ).

End of the caution.

Note on the programs wdpsastr.exe and wdpsast2.exe

The programs differ in that they export the data from the ERP system with data type “DATS” to different data types in Microsoft Access. Use whichever of the two programs files best meets your requirements.

  • wdpsastr.exe converts DATS fields to the Access format “Date/time”.

  • wdpsast2.exe converts DATS fields to the Access format “Text”.

There is no equivalent to wdpsastr.exe in Access 97. The program wdpsas97.exe corresponds to wdpsast2.exe.

See also:

Interface Format