The SIMPLE way to do this is to run an EXCEL web query which will load your data into a spreadsheet and you can then import this stuff into SAP by a zillion standard methods.
You could probably even launch the EXCEL application from SAP but you'll need a bit of programming know how for that.
You can also automate the web query but you need to know some VBA and EXCEL macro coding.
Anyway in EXCEL use the tab GET EXTERNAL DATA, enter the url of the site you want to visit and click on the green arrows on the table data you want to import.
The spreadsheet will prompt you to specify which spreadsheet cell you want to start the import at. .
Other methods could be used such as getting the data via a Portal or other Internet service but to me it seems easy just to use a browser and Excel. Manually getting the data into SAP shouldn't be a problem either.
Cheers
jimbo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.