Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    20

    Unanswered: Importing but ignore errors

    Hello. I have 2 very similar issues

    I need to append/import a xls into a pre defined table but I need it to ignore columns whose column names do not have a matching Field name in the target table

    Similarly I need to import/append a access table to the same predefined table. I want the fileds with matching names to update but any extra source fields to be ignored.

    Any Ideas ??

    Gerry

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    You'll have to program that function - either in Access or in Excel (the code would be essentially the same in either case).

    Copy/Paste from Excel to Acces does not verify field name - it only verifies data type (and it only does that to the extent that it errors if it can't determine the "closest match" such as when it can't get a valid date to place in a date field).

    Sorry!

Posting Permissions

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