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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

705 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now