Results 1 to 4 of 4
  1. #1
    ezybusy is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2015
    Posts
    119

    Import data into multi-select combo box

    Hello everyone,


    i would like to know if there is a way to import data into a multi-select combo box.

    I have an excel sheet that has about 421 records, and i definitely can't enter all of these record manually (by typing).
    However, my access table has a multi-select combo box. And any time i try importing my records i get some error.

    Note:
    ------
    Combo Box field is NUMBER.
    thx

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    you need to import to the table the multiselect field references

  3. #3
    ezybusy is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2015
    Posts
    119
    How do i import to the table the multiselect field references ????

  4. #4
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    can't answer without knowing your table structure but there are a number of possible ways. copy/paste or with vba use transferspreadsheet are two methods

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

Similar Threads

  1. Replies: 5
    Last Post: 12-17-2014, 10:31 AM
  2. Replies: 5
    Last Post: 12-26-2013, 02:19 PM
  3. Replies: 6
    Last Post: 05-15-2013, 03:36 PM
  4. Turn a list into a Multi select combo box
    By seth1685 in forum Programming
    Replies: 1
    Last Post: 01-11-2012, 07:52 AM
  5. Multi Select Combo box for print function
    By jparker1954 in forum Reports
    Replies: 11
    Last Post: 09-17-2011, 03:08 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