Results 1 to 3 of 3
  1. #1
    RustyRick is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2016
    Location
    NW Alberta
    Posts
    53

    Importing

    I have gone around and around on this one. I trying a simple import of 6 columns from Excel or csv. Done simple import man times. But this tme, I need 2 fields to be Lookup Fields. I ca get all but one column to import. Never the last one.

    After it's import I need two fields to be "Lookup Wizard" dropdown lists. When I change the fields format, all data from that column disappears.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Advise not to build lookups in table, build combobox on form.

    Could you provide file for analysis? Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    RustyRick is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2016
    Location
    NW Alberta
    Posts
    53
    good advice June thanks

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

Similar Threads

  1. Importing XML
    By ampd85 in forum Access
    Replies: 4
    Last Post: 04-22-2014, 08:17 AM
  2. Importing CSV
    By mike02 in forum Access
    Replies: 5
    Last Post: 08-01-2012, 05:21 PM
  3. Importing a PDF
    By JHighley in forum Access
    Replies: 6
    Last Post: 07-24-2012, 08:39 AM
  4. Need help importing to SQL
    By winterh in forum SQL Server
    Replies: 14
    Last Post: 03-28-2012, 12:36 PM
  5. Help with Importing
    By Souperbc in forum Programming
    Replies: 2
    Last Post: 04-13-2011, 12:45 PM

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