troubleshooting Question

SAP data online ordering from excel file

Avatar of GeekFreek
GeekFreekFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft ExcelSpreadsheetsEnterprise Software
3 Comments1 Solution281 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros