Buying Creation of Database from Excel Spreadsheets

Discussion in 'Programming' started by ninehigh, Aug 11, 2009.

0
  1. #1
    I am open to suggestions as to what database will work best for this application. Please include the database program that you intend to use with your response.

    Goal: Combine multiple spreadsheets into one searchable and sortable master database by merging three Microsoft excel spreadsheets.

    The database needs to be able to be sorted by all fields in the spreadsheets including:
    • State
    • Rep #
    • Customer Type
    • Customer Title
    • Zip Code
    • Lead Source*

    *Lead Source may have multiple values. ie. A customer that is both a “direct mail” and a “tradeshow” contact must be displayed in both “direct mail” and “tradeshow” lists.

    The purpose of this database is to generate specific mailing lists. If I say that I would like to have a mailing list of all "Michigan" reps in the zip code "48823" I would need it to generate a list of all contacts that fit that criteria. This list would ideally be output to Excel or CSV format.

    All of the existing excel spreadsheets have the same format in excel.

    Let me know what you can do, what program you will do it in, and the cost.

    Thanks
     
    Last edited: Aug 11, 2009
    ninehigh, Aug 11, 2009 IP
  2. senthil_sivanath

    senthil_sivanath Member

    Messages:
    360
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    35
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Sending PM.
     
    senthil_sivanath, Aug 11, 2009 IP
  3. ankit_frenz

    ankit_frenz Active Member

    Messages:
    1,111
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    63
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    MYSQL

    $75

    Thanks
     
    ankit_frenz, Aug 12, 2009 IP
  4. phptechie

    phptechie Well-Known Member

    Messages:
    885
    Likes Received:
    10
    Best Answers:
    2
    Trophy Points:
    165
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    Hi,

    This can be done using PHP/MySQL.

    I can help you import the spreadsheets into MySQL db & then will create a php form where you can select the criteria to export the result mailing list to CSV or Excel.

    If you are interested , then we'll proceed.
     
    phptechie, Aug 12, 2009 IP