Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2008
    Location
    California
    Posts
    17
    Thanks
    2
    Thanked 1 Time in 1 Post

    New to creating a database

    Hello everyone,

    I am trying to create a database from an Excel spreadsheet. I looked at a couple of articles on how to convert an Excel spreadsheet to a database such as Microsoft Access and it looks fairly easy. With all the different types of database software that is out there, like Microsoft Access, MySQL and MS SQL Express, which database program should I use? Thanks in advance for any tips or knowledge.

    Trinh4life

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    T4L,

    Welcome to the Lounge as a new Poster!

    For someone new to databases, IMHO, I'd recommend you stick with Access and then move to one of the others if, and only if, you outgrow the capabilities of Access.

    If converting from Excel make sure all your columns have Titles in ROW 1 (preferably w/o spaces) and that you have NO BLANK columns between your columns containing data.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    New Lounger
    Join Date
    Dec 2008
    Location
    California
    Posts
    17
    Thanks
    2
    Thanked 1 Time in 1 Post
    Thanks for the tips RG.

Posting Permissions

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