How can I pull data from web server into Excel?

Posted on 2013-06-05
Last Modified: 2013-06-05
Hi all.

We are thinking of having a website where the end user chooses a store number and enters a quantity. We then want to have that data populate 2 fields on an Excel file we use to calculate costs etc.

How can we do this? The Excel file is not on the web, it is used in our accounting department.

Thank you in advance!
Question by:Sim1980
  • 3
  • 2
LVL 10

Expert Comment

ID: 39222517

If you don't have a website already then you'll need to decide where the website stores its data. If it's in a database then you should in theory be able to query that database from Excel, maybe with a "refresh" button which pulls the latest data through, but it may take a little bit of coding in VBA to achieve this.

There are a lot of questions to be answered if you're at the "just thinking" stage though; are you writing the website yourselves, who will host it, is the user's data stored permanently or only when they place an order, etc. These are just off the top of my head, there's a whole industry set up around this!


Author Comment

ID: 39222554
Thank you for the reply John.

We already have a company website that has our company information and contact info, very basic. What do I ask them as far as where they store our data? I've read "dedicated server" on some web hosting website, is this correct?

The website would have one drop down box for the "store number" and then a text box where they enter the quantity.

We just want to be able for them to do this while they are at the store. They simply hit submit from their phones and that information would be stored "in the cloud", then we would pull that data in our office.
LVL 10

Accepted Solution

plummet earned 500 total points
ID: 39223077
It sounds like your company website is a simple set of HTML pages, in which case they probably don't store data anywhere. If you want to start getting information from website viewers you need some way to capture it. Typically this could be into a database, such as Microsoft SQL Server or MySQL. However it may be simpler to send this information in another way, such as an email message, especially if there isn't much data. There are a lot of different ways to capture and store information.

You need to get an expert to look at the current setup to see what you have, work out your requirements with you and help you design the new website which could be hosted on either a dedicated server or shared hosting, depending on the size of your website and indeed your budget. A lot of shared hosting (such as the one I have) costs very little and includes databases in the package.

It's not really possible to analyse your requirements without getting much more detail, but I hope that gives you some ideas. I'll have a think about other methods of capturing information and let you know if I come up with anything interesting.

Author Closing Comment

ID: 39223138
Thank you for your help!

Would you mind telling me what shared hosting you use, just so we know where to start?
LVL 10

Expert Comment

ID: 39223161
Of course, I use EUKHOST here in the uk, I have their Windows shared hosting, silver package. There are many such companies around and I expect they offer pretty much the same thing, but EUKHOST's support has always been quite good. Based in India, of course :-)

If I had some serious websites I would invest in a dedicated server, because otherwise you're sharing servers with potentially hundreds of others.

I hope that helps, if I can help any more let me know.


Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

770 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