Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011

    Unanswered: Mapping table import to columns in an excel sheet

    Hi all.

    I need to import a group of excel spreadsheet. They all have the same columns names but are in different order. In sme cases the used has added an extra column or two. See examples below

    MS Access Target Table
    Column_A Column_B Column_C

    Column_A Column_B Column_C

    Column_B Column_A Column_C

    Column_C Column_B Column_A Column_Z

    Can I have a generic Access import process that can match the source and target columns above them import the data?

    Thanks in advance for any help

  2. #2
    Join Date
    May 2004
    New York State
    The reliable way, in my experience, is to link to the Excel file, and then to create a Create Table Query or Append Query to an Access table with the structure the way you want.

    I've never been able to do mapping, which is not to say it can't be done.

    Good luck,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts