Go Premium for a chance to win a PS4. Enter to Win


How can I pull data from web server into Excel?

Posted on 2013-06-05
Medium Priority
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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

971 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