Results 1 to 12 of 12
  1. #1
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6

    Unanswered: need me one them database thingies

    my boss said i need to put all of my spreadsheets into a database.

    is this hard?

    do databases have an import utility or am I going to have to retype everything?

    Is SQL harder than Excel or is it just about the same thing only fancier?

    Do you forsee any problems with this approach?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the only problem i foresee is that you're in the wrong forum

    you want to be looking at Access, not SQL Server

    other than that, it's a cakewalk
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    i have to admit something kind sir. this is really homework for my 400 level systems srchitecture class this semester.

    would you happen to have one of these ERD thingies and a complete project plan I can hand in on Monday. I was supposed to start on this in August, but me and the frat brothers have just been drinking every night and seducing frshmen girls. Been busy.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Tell your boss that this is unnecessary. Excel is an excellent database itself, and more flexible since it does not impose any "rules" or "constraints" on the data. He'll see the sense in this, I'm sure.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ah a slow day troll

    Maybe Lotus1-2-3
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You guys know that somebody is bound to take you seriously, and might even try to make sense of this drivel.

    -PatP

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Well, an ERD (or Entity relationship Diagram) just shows how entities relate to each other. This is really just a family tree kind of concept. Google around for a copy of Thomas Jefferson's family tree, and use that for your assignment. As for the project plan, hardly anyone uses those in the "real world" it seems. it is unlikely that your professor has actually seen one outside of an academic setting. The one thing you need to know about making a project plan is that all project plans have one thing in common. A PowerPoint presentation. This one has been popular for some time, and should get you the grade you deserve in this class:

    http://norvig.com/Gettysburg/sld001.htm

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    So does that mean that ERDs are inherantly more complex in Kentucky?

    If I build a project plan with only one step, failure, is that complete or is a prelimnary step required in a project plan?

    Sooo many decisions! Now I see why those data guys get paid so much.

    -PatP

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Easy.... Print off your spreadsheets on to paper and file them away in your filing cabinet. That's just and old skool database, isn't it! You'll probably get high marks for research and originality for that one.
    George
    Home | Blog

  10. #10
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    Quote Originally Posted by Pat Phelan
    You guys know that somebody is bound to take you seriously, and might even try to make sense of this drivel.

    -PatP
    don't be a hater, people are trying to help!


  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Pat Phelan
    So does that mean that ERDs are inherantly more complex in Kentucky?

    bwahahahaha
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Hmm....did someone in here just get a second monitor?

    http://www.dilbert.com/comics/dilber...-20071016.html

Posting Permissions

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