Ask the Expert

Loading Excel spreadsheets into SAP

I would like to know how to up load an excel spreadsheet into SAP for journal entry purposes (i.e. spreadsheet format and the path in SAP to do this or how to create the path).

    Requires Free Membership to View

There are software packages available off the shelf designed to automatically upload spreadsheet data into SAP. Some of the more sophisticated ones are written in Visual Basic, but the operation is similar to macros: go down one cell, move right two cells, grab the value in that cell, switch to SAP, paste the value here, switch back to the spreadsheet and repeat the process.

These programs require discipline in the spreadsheets - the next number to be input should always be the same relative cell reference (for example, down one cell then right two cells). Otherwise, you'll have a tough time programming the upload software to handle the inconsistencies in spreadsheet locations.

This was first published in May 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: