Results 1 to 6 of 6
  1. #1
    OroTrainee is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2018
    Posts
    4

    Unhappy Import from excel to multiple choice list

    Hello guys,


    I'm trying to import data from excel to access, and i can't find how to import data on a multiple choice (checkbox list) field..
    I can't paste any data on the field either

    The checkbox options come from a table.

    My question is, is it possible to enable input datas on those fields ? Or at least past some data on it ?
    Thank you in advance guys

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You import excel sheets all at once to A table.
    Once that happens,what do you want to do with a multi list?

  3. #3
    OroTrainee is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2018
    Posts
    4
    Hello, thanks for the quick response !

    so i have this particular field, and when i import data from excel, it doesn't update at all, even if i export the table from access to excel, and then tried to reimport it into access, it doesn't work at all. as i said, options come from a table (here i just show the index on options)
    On other table i had to complete same fields but with multiple choice disabled, and it work fine, but with the multiple choice enabled, i can't find a way to import data.. I tried to paste an option name, an index option, and nothing works

    Click image for larger version. 

Name:	showforum.png 
Views:	19 
Size:	26.1 KB 
ID:	34786

  4. #4
    OroTrainee is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2018
    Posts
    4
    any hint someone ?

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Not clear what you've got or what the image is about. Is that a form? Query? Table? Is it a lookup field in a table? If so, see http://access.mvps.org/access/lookupfields.htm for more info.
    Is it a multivalue field in a table? If so, IMHO, that is the root of your problem, compounded by using tables for data entry. I don't have any good links about why not to use mvf's if you're not interacting with SharePoint lists. Google multi value field and decide for yourself if they are something to avoid. You will find out that you're basically dealing with a reference to a hidden table that cannot be exposed. They are not exactly the same thing as a lookup field; some articles will confuse the two but from what I know, the issues pretty much apply to either of those field types.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    OroTrainee is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2018
    Posts
    4
    okay, thanks, I can't really change the table because it's a huge base access from an enterprise. i have completely change my way of doing it, thanks for trying to help me guys !

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

Similar Threads

  1. Replies: 2
    Last Post: 03-13-2018, 11:08 AM
  2. Making a multiple choice list searchable
    By dwheatley in forum Queries
    Replies: 8
    Last Post: 12-13-2017, 03:41 AM
  3. Replies: 7
    Last Post: 09-14-2017, 02:24 AM
  4. Replies: 0
    Last Post: 03-19-2017, 01:29 PM
  5. Query missing from list - Import to Excel
    By T1969 in forum Import/Export Data
    Replies: 2
    Last Post: 02-12-2017, 02:07 PM

Tags for this Thread

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