Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Converting a lender list to a detailed database???

Discussion in 'Information Technology' started by nfranklin06, Jul 28, 2006.

  1. nfranklin06

    nfranklin06
    Expand Collapse
    Guest

    Hello,

    I have a lender list in access that is done as an Excel spreadsheet, with
    Acct Exec. contact information. I want to make it more detailed as far as the
    programs the lender offers, max LTV's, if they do seller seconds, minimum
    credit score, max seller concessions, etc. I believe there is a way to make a
    database and to transfer the info I already have into it. I shouldn't have to
    retype all info on the Lender list right??

    Thanks for any help!

    Nicole
     
  2. Loading...

    Similar Threads Forum Date
    Jehovah's Witnesses Are Out And Converting! Blogs Jul 31, 2016
    Basic Questions about Converting to Sikhism Questions and Answers Nov 15, 2013
    Converting to Sikhism Hard Talk Aug 31, 2012
    Why are people converting to Sikhism? Sikh Sikhi Sikhism Jul 1, 2012
    Question About Converting To Sikhism For A Married Person Questions and Answers Jun 3, 2012

  3. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    No, you don't have to retype the data. Before you start using Access, I
    strongly recommend a little education. The most important thing is properly
    structuring your data. If you simply import your spreadsheets and continue
    working as if you were still using a spreadsheet, you will be veeeeery
    unhappy with Access.

    The data that you currently have in one sheet might need to be loaded into
    several tables. Look for repeating groups. Those would be similarly named
    columns that just have suffixes (acct1, acct2, etc) or represent periods of
    time (Jan, Feb, Mar, etc). These need to be "normalized". Search for
    "database design" and "normalization" for starters.

    To import your spreadsheet into Access just to see what's what, use File/Get
    external data/Import and find your spreadsheet in the browser. The wizard
    will walk you through the import process.


    "nfranklin06" <nfranklin06@discussions.microsoft.com> wrote in message
    news:5FCB1F60-53DF-4EF1-8A9D-20CF40CB7BFB@microsoft.com...
    > Hello,
    >
    > I have a lender list in access that is done as an Excel spreadsheet, with
    > Acct Exec. contact information. I want to make it more detailed as far as
    > the
    > programs the lender offers, max LTV's, if they do seller seconds, minimum
    > credit score, max seller concessions, etc. I believe there is a way to
    > make a
    > database and to transfer the info I already have into it. I shouldn't have
    > to
    > retype all info on the Lender list right??
    >
    > Thanks for any help!
    >
    > Nicole
     

Share This Page