Computing.Net > Forums > Office Software > Unparsable Record in Access

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

Unparsable Record in Access

Reply to Message Icon

Name: MrBedo
Date: August 2, 2005 at 08:01:04 Pacific
OS: WinXP Pro
CPU/Ram: 1gb
Comment:

I am trying to import a .csv file into Access 2000 but each time I do I get an _ImportErrors table full of Unparsable Record errors.

I have checked the csv file and there is nothing untoward about the formatting of the particular rows and columns that Access errors on. I have read that it happens when access finds a character that it believes to be a delimited value, but this isn't the case with my data.

The csv file contains 63 rows and 238 columns, is this too much for Access to handle, could that be why it errors ?

Any ideas would be greatly appreciated.

cheers

rich



Sponsored Link
Ads by Google

Response Number 1
Name: A Certain TH
Date: August 8, 2005 at 15:43:45 Pacific
Reply:

I'm not an expert at Access, but I think you'll get this error if it has assumed a datatype which it cannot then apply to the whole file. It sounds like there is a numerical field in the first line, which has a subsequent text entry.

Another common one is to have "YES" or "NO" or "TRUE" or "FALSE" in the first line, and then to subsequently have "MAYBE" - when Access has assumed that it is going to be a YES/NO field.

[btw: 63 x 238 is of very little consequence to Access]


0
Reply to Message Icon

Related Posts

See More


HELP - Excel too many arg... MC Outlook Deletes Read M...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Unparsable Record in Access

Select specific Records in access www.computing.net/answers/office/select-specific-records-in-access/4551.html

Select specific Records in Access 2 www.computing.net/answers/office/select-specific-records-in-access-2/4560.html

Remove Duplicate Records in Access www.computing.net/answers/office/remove-duplicate-records-in-access/3275.html