SAP data online ordering from excel file

Posted on 2007-07-24
Last Modified: 2013-12-08
I would like to develop an ASP page that the user can complete a form.  I would like to query the excel file with data from the form and if a certain condition is met I would like to update the excel file.  The excel file will be then uploaded.

This is for an online ordering system.  It is a very long wided system that we use.  Basically a manager asks us to add an account for online ordering.  I then have to add data to an excel speadsheet.  Data is drawn from our main company database (SAP) and stored in an excel file.  A Formula is in the excel spreadsheet that performs a lookup on the data to test if the account details match from that what I have entered manually.  I then have to perform a sort on all of the data then delete a column.  Then upload the excel file for online ordering so that users can log in for online ordering.

Wow I can hear you scream! that's a shedload of work. I know. So basically if I want to add a user for online ordering I have to update the excel file with every username & login & upload. Suggestions would be most gratefully received.

Thanx in advance

Data from the main business database is downloaded from the SAP system to an excel file. The excel file has to be checked so that I know that account numbers match. I can then
Question by:GeekFreek
    LVL 29

    Accepted Solution

    >>I can then...

    The suspense is killing me ;-)

    Why not use Access for this? You can link to your SAP database, write queries against it (for customer name retrieval), and create forms/reports to ease your pain.

    Author Comment

    Thanks.  I kind of thought that would be the best option.  much appreciated.
    LVL 29

    Expert Comment

    No worries - glad to help.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
    Note: You must have administrative privileges in order to create/edit Sharing Rules. ( (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now