Consulting

Results 1 to 3 of 3

Thread: Export Problem

  1. #1
    VBAX Regular
    Joined
    Feb 2009
    Posts
    23
    Location

    Export Problem

    I just got some updated data to add to my report and all of a sudden when I try to export I get this error:

    'Microsoft Access Unable to Append All the Data to the Table

    The contents of 1 field were deleted and 0 records were lost due to key violations...'

    WTF? I'm transferring an access query that work fine to a new excel spreadsheet. How can there be any key violations?

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Without seeing code, it is hard to help.

  3. #3
    VBAX Regular
    Joined
    Feb 2009
    Posts
    23
    Location
    No code. This happens even when I use the export wizard.

Posting Permissions

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