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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

792 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