Results 1 to 3 of 3

Importing failed from Excel to Fields setup to allow multiple values?

  1. #1
    Brett Sickels is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    May 2017
    Posts
    2

    Importing failed from Excel to Fields setup to allow multiple values?


    I am trying to import data from Excel into a Database table that I created in Access, but any field that I created in the database to Allow multiple values wont import?
    If I allow it to create a new table from the excel info, it imports the info, so why wouldn't it import into fields assigned to allow multiple values?

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,049
    This may be some help but the short story is you can't do it directly
    https://social.msdn.microsoft.com/Fo...orum=accessdev



    Sent from my iPhone using Tapatalk
    Andy to all.
    (Is your topic sorted? Please mark your thread as solved)

  3. #3
    Brett Sickels is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    May 2017
    Posts
    2
    Thank you Andy49 for the prompt attention, your input provided what I needed to know!

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

Similar Threads

  1. Replies: 3
    Last Post: 06-14-2016, 11:59 AM
  2. Replies: 22
    Last Post: 12-29-2015, 10:41 PM
  3. Importing Multiple Excel
    By sathishkm in forum Import/Export Data
    Replies: 3
    Last Post: 02-28-2013, 03:13 AM
  4. Importing numeric fields with null values from XML
    By hcorvallis in forum Import/Export Data
    Replies: 1
    Last Post: 10-20-2011, 08:09 AM
  5. Importing Excel file. (2 non numeric values won't import)
    By Amerigo in forum Import/Export Data
    Replies: 3
    Last Post: 05-20-2011, 11:31 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
  •  
Tech Forums: Microsoft Office Forums