dcsimg
www.webdeveloper.com
Results 1 to 5 of 5

Thread: Best way to store excel files then have form to query?

  1. #1
    Join Date
    Feb 2010
    Posts
    5

    Question Best way to store excel files then have form to query?

    I am completely new to this and a I apologize if I am postihng this in the wrong area.

    Here is what I am trying to do.

    Upload or "store" EXCEL files on my server and then have a "FORM" clients can fill out in order to see the info I uploaded in excel format.

    I was thinking that I should use either HTML or ASP to build the form and then MYSQL to store the data.

    What would be the best way for me to get the excel data stored on my server and then have a page with a FORM for clients to go to and be able to see the data from the excel file?

    I also want the form to have drop down selection boxes so that the client can chose which data from the excel file they want to see.

    Any help is much appreciated.

  2. #2
    Join Date
    Apr 2008
    Posts
    190
    Create a table and load the spreadsheet data into it. You will probably want the data in a CSV format. Look up LOAD DATA INFILE command for MYSQL. THen you need to use some ASP to read the form submission and put the table data in some sort of control.

  3. #3
    Join Date
    Feb 2010
    Posts
    5
    Thanks for the reply, but I am very confused

    I am trying to create a form on a financial website so that clients can go to the form on a web page and first "LOGIN"

    Once they login, they will be presented with a form with drop down menus asking them WHAT info they want to see. (name, company, deposits, withdrawals, intere3st, etc... and then once they make their selections and hit submit, the info is pulled from the database and displayed on the website.

    The database is on our company server and is MS SQL (Not MYSQL)

    I have access to the database and MS Server 2005 and visual server 2005 and I can see the login name for me and the database name, but I have no idea how to connect the database to the form. How to query certain data or even how to have the form find the database for that matter.

    I am very familiar with installing Joomla websites on MYSQL databases and how to connect the config file for the website to the MYDQL database, but with this project I am way in over my head.

    My boss wants me to figure it out and I am usually good at doing that, but this has me baffled.

    First I need to know how to even connect to the database through a website and then have the form fields set so that whatever the client selects, that is what he gets.

    I don't want to have to tell my boss I can't do this, because I am sure with enough Googling and asking around I can figure it out, but any help here would be greatly appreciated.

  4. #4
    Join Date
    Apr 2008
    Posts
    190
    Quote Originally Posted by VeraxTek View Post
    First I need to know how to even connect to the database through a website and then have the form fields set so that whatever the client selects, that is what he gets.

    I don't want to have to tell my boss I can't do this, because I am sure with enough Googling and asking around I can figure it out, but any help here would be greatly appreciated.
    What you are asking for is a fairly simple website procedure and you can find a tutorial faster on google than by me trying to explain it. While it may be simple, it still incorporates a couple different aspects that you will have to understand in order to get it to work. If you have no experience in either programming or database queries then you have some learning to do. I won't do it for you but I can point you toward some google searches.

    http://www.webcheatsheet.com/ASP/dat...connection.php - This one will show you how to connect, query, and display the result.

    You then need to be able to handle the form submission to modify your query.

    http://www.tizag.com/aspTutorial/aspFormsPost.php - This will show you how to handle form posts. Use the variable from the form posts to modify your query you built from the first example.

    Hope this helps!

  5. #5
    Join Date
    Feb 2010
    Posts
    5
    Thank you so much for the reply and the links. This helps a LOT!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles