have csv file which was created from a sas dataset and has around 450 k records. Since the number of records is high I need to load it into ms access(MS Access 2000). The problem is that 82 records do not load properly. With some versions of ms access it even does nt through import errors. We came to know of these records when it threw errors in older versions. The problem is that for these 82 records the data gets truncated after a field.It differents for every record. We tried loading it back into Sybase and SAS and it worked fine.
Pls suggest if we can resolve this using newer access versions.
Without examples of the data or the Access import and/or table specifications this is hard to diagnose.
With that said, from headaches with Access in the past I would look for delimiters in a text variable. If that is the case your data needs to be cleaned, a different delimiter needs to be used or ensure that string variables are quote qualified.
If so, the csv file is probably fine, and the error is with MSaccess. From your description, could it be that access cannot read very long CSV records? How many characters until the data gets truncated? Do records that read fine have similar lengths?