Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Boston, Massachusetts, USA
    Thanked 0 Times in 0 Posts

    Data lost during import (Access 97)

    I have a dataset that I have downloaded from a company system. I put this info into a text file. In Access, I use the import function. When I import, access is dropping records. Linking does the same thing. Am I missing something while importing? I've added a small sample of my dataset and the matching query results which show the case numbers that don't pull over in the import.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Data lost during import (Access 97)

    Without more information it isn't possible to figure out what is happening. What format is the data downloaded in? If it is a fixed width text file, rather than delimited, then it sounds like there is something wrong with the import spec you're using. Given the fact that at least some of the records that were'nt imported are short or preceded by short records, it's possible that the information is getting wrapped and winding up appended to a different record. This could happen if Access is unable to distinguish the end of a record due to the structure of the text file.

Posting Permissions

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