Derek Brown
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you both
ASKER
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?