Results 1 to 2 of 2
  1. #1
    zwieback89 is offline Novice
    Windows 2K Access 2010 64bit
    Join Date
    Jun 2012

    Import Data from Excel File


    I imported the data from the Excel file into a brand new table in Access 2010. I chose not to import several columns since these are not needed in the table. To do this, I would click on the check "Skip Import". After choosing the columns to skip and importing it into a brand new table, Access prompted me to save the import so that I can re-use the map, if needed. However, when I look at the table design, I see all the columns instead of the selected columns I chose to import. Any ideas?


  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Tulsa, Oklahoma.
    I duplicated your steps - exactly like you described - and Access did not import the fields that I told it to skip.

    Did you try the process again? It should work without a problem. I do this a lot and it has always worked for me.

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

Similar Threads

  1. Import Excel file to Access
    By emmett in forum Import/Export Data
    Replies: 3
    Last Post: 04-06-2012, 05:27 AM
  2. create a button for import excel file
    By tggsun in forum Forms
    Replies: 3
    Last Post: 01-17-2012, 08:40 AM
  3. Browse for Excel File and Import
    By AKQTS in forum Programming
    Replies: 1
    Last Post: 07-12-2011, 07:33 AM
  4. Excel Import - File with row spaces
    By Jackfam58 in forum Import/Export Data
    Replies: 1
    Last Post: 04-13-2011, 07:35 PM
  5. Import Excel File Using Macro?
    By oregoncrete in forum Import/Export Data
    Replies: 0
    Last Post: 04-05-2011, 12:26 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