Problem solve Get help with specific problems with your technologies, process and projects.

Linking Excel to SAP

Linking Excel to SAP

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.

This was last published in May 2001

Dig Deeper on SAP Basis administration and NetWeaver administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.