Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import table from Excel (A2k)

    I have a small list (about 100 records) with 7 categories of information, the first 3 being Fname, Mname, Lname. This is a spreadsheet used to keep track of donations made by some of our members. The way the list is currently set up in Excel is that there are some donators who are listed several times, due to different donation amounts, to different accounts, for different reasons, etc. It's the end of the day and I'm having difficulty figuring out the best way to convert this to Access. I'm gonna need a table for donators, donation amounts, donation source, and donation accounts. I'm having trouble imagining how to let the wizard do this and avoid "losing" any data. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Import table from Excel (A2k)

    It sounds as if you need a few tables. There are several ways to do this, however, I would suggest the following logic. You have many donators. Each donator can donate funds one or many times. Each fund could have one or many accounts or sources. Thus create one table such as a donator master that could contain a unique id, donator name, address, and other general information.
    Create another table called donations and another for unique accounts. Link the donator table to donations as a one to many such that each donator can donate multiple times. I would also link the account as a lookup to the donations table and tied to each donation.

    So, you would only input a donators general information once. Then each time a donation is made, update the donation amount and the account type. Is this what you are looking for?

    HTH
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Import table from Excel (A2k)

    How are you going to use these data in Access? In theory, it is certainly much better to create a proper relational structure, but for the moment, you might just import the Excel table "straight" into Access. You can use the Table Analyzer (Tools | Analyze | Table) later on to get suggestions on how to split it.

  4. #4
    3 Star Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import table from Excel (A2k)

    Thanks Gary (and Hans!). I knew this was the direction I needed to go. It's been several months since I had to actually design a database, and the first and last project I worked on was about a 6 month journey, to which Hans can surely attest. Since then I've just been making form and report design changes and my "knowledge" of tables and relationships sort of slipped out the hole in my head. <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

Posting Permissions

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