How to link Ms SQL Server To SAP Front End

Dear All;

Just in case this topic is already covered, we want to allow SAP to tap data from MS SQL Server 2016 Express Database so that whatever people are processing from Ms Access 2016 which is linked to Ms SQL Server 2016 will automatically reflect in the SAP report.

The reasoning behind this is that there are some tax information we cannot process in SAP but are easily done in Ms Access developed software, and so the only way is to share the Ms SQL Server 2016 tables for the sales part only SAP. The record source for SAP sales reports will now be pointing to Ms SQL Server 2016.

I was thinking that maybe there is some kind of ODBC string like below that can be used.

strConnectionString = "ODBC;DRIVER={sql server};" & _
        "DATABASE=" & MDCaPremier & ";" & _
        "SERVER=" & USER\SQLEXPRESS & ";" & _
        "UID=" & UID & ";" & _
        "PWD=" & PWD & ";" 

Select allOpen in new window