Solved

How can I pull data from web server into Excel?

Posted on 2013-06-05
5
269 Views
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!
0
Comment
Question by:Sim1980
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:plummet
ID: 39222517
Hi

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!

Regards
John
0
 

Author Comment

by:Sim1980
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.
0
 
LVL 10

Accepted Solution

by:
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.
0
 

Author Closing Comment

by:Sim1980
ID: 39223138
Thank you for your help!

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

Expert Comment

by:plummet
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.

Regards
John
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

622 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