Results 1 to 2 of 2
  1. #1
    narendrabr is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2013
    Posts
    21

    how to select required fields when importing text file to acces 2010?

    Hi,


    I have number of fields in the text file but need only few fields to be imported to access.How do I do that?

    Thanks,!

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    When importing through the Import Wizard, when you get to the screen with the Field Options, there is a check box for "Do not import field (Skip)".
    Check this box for all the fields you do not wish to import.

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

Similar Threads

  1. Importing A Text File
    By steve2507 in forum Access
    Replies: 5
    Last Post: 02-28-2012, 01:48 AM
  2. Importing a text file
    By Kurs in forum Access
    Replies: 11
    Last Post: 02-20-2012, 02:26 PM
  3. Importing text file with blank fields changes to null
    By Egoyret in forum Import/Export Data
    Replies: 9
    Last Post: 11-10-2011, 01:51 PM
  4. Importing large txt file into Access 2010
    By Jimbo in forum Import/Export Data
    Replies: 6
    Last Post: 06-30-2011, 08:26 PM
  5. Replies: 1
    Last Post: 11-05-2010, 04:31 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