SAP queries in MS Access

[Former Member]

Hi Guys,

I usually refresh queries in BEx analyzer in Excel and then export it to MS Access.

Is there a way, I can run SAP queries directly in MS Access.

[former_member186696]

Hello Subbiah,

There is no tool to access BW directly via MS Access.

I don't have access installed here, but maybe you can connect via ODBC.

This option is available for Excel.  I think it is also available for Access.

You can refer these notes to download the driver:

1858722	SAP BW ODBO driver 64-bit available - SP 02
1782145	SAP BW ODBO driver 64-bit available - SP 01
1496637	SAP BW ODBO driver 64-bit available - FCS

Best Regards,
Edward John