BookmarkSubscribeRSS Feed
w020637
Calcite | Level 5
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
2 REPLIES 2
ballardw
Super User
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.
ChrisNZ
Tourmaline | Level 20
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?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 751 views
  • 0 likes
  • 3 in conversation