Can we create online database using excel

Discussion in 'MySQL' started by selfspirit50, Oct 13, 2006.

  1. #1
    Hi guys,
    I want to create a database mangaement system such that which can be shared by other people too...it can be edited, saved and take printout online.

    I want to make a excel sheet containing living expenses which can be updated and modified by any number of user.

    Can some one help me with maintainence of database management for such website
     
    selfspirit50, Oct 13, 2006 IP
  2. sacx13

    sacx13 Active Member

    Messages:
    438
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #2
    Such a software it's doesent exist ... but you can have some alternatives if your users will learn how to use csv and phpmyadmin ... is not a big job but in this way you can update your database from excel files :) but manualy.
     
    sacx13, Oct 14, 2006 IP
  3. pangea

    pangea Guest

    Messages:
    557
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #3
    could you try using googles spreadsheet options? and letting everyone edit it by adding their emails to your friends list?

    just an idea!
     
    pangea, Oct 25, 2006 IP
  4. mahmood

    mahmood Guest

    Messages:
    1,228
    Likes Received:
    43
    Best Answers:
    0
    Trophy Points:
    0
    #4
    As far as I know MS Excel cannot manage large amount of data. It is only suitable for less than 250 rows.
     
    mahmood, Oct 30, 2006 IP
  5. number7

    number7 Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I suggest you DB + Export to Excel scheme. Excel could not handle multiple users on the same file and data errors will occur.
     
    number7, Nov 3, 2006 IP
  6. kjewat

    kjewat Active Member

    Messages:
    149
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #6
    How about creating an MS Access database? That should be pretty easy without needing much knowledge about SQL and other database stuff..
     
    kjewat, Nov 3, 2006 IP
  7. jeremyweber

    jeremyweber Peon

    Messages:
    112
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Sure, what are the requirements and how much are you willing to pay? Seriously, questions like this always kill me. ( Can you help me create this application = I have no idea what I am doing, will someone do it for me? ). If you are serious about this type of stuff, you can definitely get help on the forums, but for God's sake ask direct questions. For example, how do I insert data into a table using PHP, etc. Showing initiative and asking intelligent questions will get you better responses.

    Sorry for the rant, but its been bugging me. If you are serious about this project, I would either pick up a book on PHP/MySQL or hire someone. You can PM me for rates:)

    Also, excel is capable of handling way more that 250 rows. Not saying its a great tool, but it is capable.

    J
     
    jeremyweber, Nov 3, 2006 IP
  8. rb3m

    rb3m Peon

    Messages:
    192
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Don't start with defining the software and then adapting the task to it. Start by describing what you want to do (i.e. I want a system that will track living expenses online for a group of people) and you'll get much better answers and even ideas to expand the concept.
     
    rb3m, Nov 3, 2006 IP
    mahmood likes this.
  9. RobertsMrtn

    RobertsMrtn Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Google docs is probably the best site to use for what you want to do.
    If you need something more than a simple spreadsheet, you could try www.recs4free.com
    This will allow you to design your own forms for data entry.
     
    RobertsMrtn, Mar 12, 2009 IP
  10. adstiger

    adstiger Peon

    Messages:
    409
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #10
    You may use Excel as a database with PHP or ASP.NET/C#
     
    adstiger, Mar 12, 2009 IP
  11. Andrew Shenderuk

    Andrew Shenderuk Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Hello guys! You can use free online database mytaskhelper.com
    You can work together with projects.
    Create database with ease))
     
    Andrew Shenderuk, Jun 29, 2009 IP
  12. adstiger

    adstiger Peon

    Messages:
    409
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #12
    I saw a demo of the similar excel as database at http://www.facebookusername.net however, now I am not able to find it. You may check there, probably you can find it.
     
    adstiger, Jun 29, 2009 IP