Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SAP data online ordering from excel file

Posted on 2007-07-24
Medium Priority
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
  • 2
LVL 29

Accepted Solution

Badotz earned 1500 total points
ID: 19555396
>>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

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

Expert Comment

ID: 19556310
No worries - glad to help.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

564 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