Results 1 to 3 of 3
  1. #1
    anakaine is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    1

    Import from excel - multiple items in a cell

    Hi all, first time post and asking for some advice. Not sure if this belongs in the import section, or design section.



    I'd like some feedback on the below in order to help achieve my goal of being able to assign values to all the ingredients in a recipe, and then query the recipe as a whole. This may be a method of importing that allows the query, or some preprocessing in excel that allows putting the data in to workable tables.

    I have a large amount of data that looks like the below in each row of excel:

    Recipe Table
    Title Unit Category Ingredients
    Baked Bread Imperial Bread Flour
    Water
    Salt
    Sugar
    Yeast


    What I'd like to be able to do is assign values to each of the ingredients so that later on I could give the entire recipe some values. Eg, if all ingredients are listed as allergy friendly, then I can assign an allergy friendly rating.

    My thinking at the moment is to break out the ingredients in to a separate table:

    Ingredients Table
    INGREDIENT FRIENDLY
    Flour 0
    Water 0
    Salt 0
    Sugar 0
    Yeast 1

    In this case:
    Allergy Friendly is 0
    Not allergy friendly is 1

    Where I get hung up is how I could structure a query to say "Look at the ingredients in the recipe, refer to the table of ingredients and give me the sum of all ingredients that match an ingredient in the "Friendly" column, because I don't know how to approach looking at each ingredient separated by a line break in the Recipe Table.

    Any suggestions as to a query that could handle this, or a more appropriate table structure would be warmly welcomed.
    Last edited by anakaine; 08-27-2016 at 02:13 AM. Reason: Clarity

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    are you still working on this?

  3. #3
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I don't see how.
    except split it in excel befor the import.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 09-19-2012, 11:49 AM
  2. Replies: 1
    Last Post: 08-25-2012, 06:11 PM
  3. import specific cell from excel to access
    By maneuk in forum Import/Export Data
    Replies: 10
    Last Post: 07-01-2011, 06:24 AM
  4. Import single cell from excel
    By zippy483 in forum Import/Export Data
    Replies: 9
    Last Post: 02-24-2010, 02:16 PM
  5. Can we post Access cell data to Excel cell properties?
    By Zethro in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2005, 08:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums