Linking Excel to SAP
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
I am trying to upload Excel s/sheet data onto SAP. I can record the data in SAP eg the fields that need to be populated etc and than download those in Excel to be populated accordingly. How do I link the data from the s/sheet to SAP? Is this a VB question or SAP?
I can not get it to work.
This is an SAP issue and it is handled using the "Data Transfer Workbench"(Transaction SXDA) or the "Legacy System Migration Workbench" (available as transports from SAPServX) and then Batch Input sessions. However, it is possible to write a VB program that reads the data from Excel and puts it in SAP. This is a more complicated method, though. And, you need to use the GUI Automation.
I recommend you get a free copy of the "Data Transfer Made Easy" guidebook at www.saplabs.com or directly at http://wwwtech.saplabs.com/datatransfer/default.asp
This guidebook will provide you all the information you need.
Dig Deeper on SAP Basis administration and NetWeaver administration
Related Q&A from Giovanni Davila
Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila.continue reading
Learn fundamentals of transport management and STMS from Basis guru Giovanni Davila in this expert tip.continue reading
Learn how to return a list of 1,000 transport requests in SAP R/3 PRD in this tip from SearchSAP.com's Basis expert.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.