The SAS Output Delivery System and reporting techniques

SAS Dataset to CSV to Ms Access ( Import errors in Ms access)

Reply
Occasional Contributor
Posts: 9

SAS Dataset to CSV to Ms Access ( Import errors in Ms access)

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.

Regards
Jeetendra
Super User
Posts: 11,343

Re: SAS Dataset to CSV to Ms Access ( Import errors in Ms access)

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.
PROC Star
Posts: 1,760

Re: SAS Dataset to CSV to Ms Access ( Import errors in Ms access)

Does the same csv file load fine in sybase?

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?
Ask a Question
Discussion stats
  • 2 replies
  • 119 views
  • 0 likes
  • 3 in conversation