Import CSV

[jsic1210]

Help! I'm trying to set up a saved import, but keep getting the following error message:

"You cannot record your changes because a value entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). Correct the error and try again"

There are a couple hundred fields, and they are all set to text. Is there a way to figure out where the problem is occurring without going through all fields?

 

[jdraw]

Did you get a table called Import_Errors or similar?
What fields have some sort of criteria -check them.
It is rare to see a table with a couple of hundred fields.

 

[Mile-O]

Is the destination table defined and is there an import specification set up? Or is a new table created on import?

Any input masks on the fields?

Any import error tables?

 

[jsic1210]

@jdraw: I did not get an Import_Errors table, it just did not import at all. I don't think any field has criteria. They are all text, some have a format of "@." I would assume that wouldn't make a difference. I wish there weren't so many fields, but I have no control over the data source.

@Mile-O: The destination table is defined. The import spec that is set up was giving me problems, so I'm trying to create a new one. I don't see any input masks, but like I said, there are a lot of fields. No import errors.

 

[kevlray]

Is the number of fields over 255 (max for Access)? I would think it would give a different error, but I have never tried that many fields before. What is the text length for the fields (defaults to 50 characters) versus how long each field is in the csv?

 

[jsic1210]

There are actually other formats in which I can obtain the data, so instead of CSV, I chose Text File Delimiter, using "|" (pipe) as a delimiter, and quotes as a text qualifier. After having to change/add field names for duplicate and blank field names, I was able to set up an import as a text delimiter. Go with what works, I guess! Thanks for all the help!