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
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 ?
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]
Summary: I want to select specific records in an Access database consisted of up to 100,000 rows. The specific column, that I want to pick up the records from, starts from A00 to U99. Each record can be from 3...
Summary: Hi I couldn’t get my answer and I thought I should post it another time: I want to select specific records in an Access database consisted of up to 100,000 rows. The specific column, that I want to ...
Summary: Can anyone please tell me how to remove duplicate records from Access 2000. I have a database with over 400,000 records and I have a lot of duplicates. Whats the easiest way to do this. Thanks for a...