Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2012
    Posts
    1

    Question Unanswered: What to use to collect data whilst SQL database being created

    Hello all

    I have just started in a brand new role where I need to collect a large amount of diverse data. Part of this data is whether the steps in a guideline has been followed ( a simple check box or yes/no) (but there are maybe 100 guidelines)

    My IT department have suggested we use SQL to create the database, but this will obviously take time. In the meantime my boss is keen that I get on with the data collection before the database is ready. I do not want to repeat steps when I create the SQL database so is there any format you would recommend I collect my data in now that can be easily applied to the SQL database - ie if I used Excel, would that be best, and should I then try to keep potential SQL table data separate?

    Sorry if that does not quite make sense - I'll happily answer questions to make it clearer

    Thanks

  2. #2
    Join Date
    Jul 2011
    Posts
    22
    I would recommend using EXCEL. Setting up and utilizing the spreadsheet should also help in the creation/design of the SQL database structure. Then when all is done, the Excel Spreadsheet should closely match the SQL database, allowing for easy import.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How is the data collected today?

    I would NOT use EXCEL

    A simple tab delimited file would be good (perhaps)

    How many files do you have?

    Are they all in the same format?

    What is contained in these files?
    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.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Whilst...

    You a Brit?

    This massage is too short
    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.

Posting Permissions

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