Link to home
Start Free TrialLog in
Avatar of Derek Brown
Derek BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

What is the best way to get purchase order data into SAP from Access

Hi All

I have a customer with a SAP ERP system. They want my poor Access ap to interact. Specifically with purchasing requirement for the materials that my Ap lists.  

They say that they can "Suck" most data formats, especially Excel into their system
SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Derek Brown

ASKER

Thank you for that.

Had a meeting with the client today they seem happiest with an excel file. Probably because the client wants to send data to their head office in Portugal. There is a shared file between the systems of both countries but I think they like the simplicity for now with excel.

What I would like is code for a button on the main form that opens the query and export the data as an excel document opens the email client and attaches the data file. Can this be done to work with any email program?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you both