on 09-16-2008 2:49 PM
I am trying to import a chart of accounts using the data transfer workbench. I am getting an error on a handful of the accounts, and I cannot figure out what it is.
The error is:
"The Field is too small to accept the data65171"
The ones that are rejected are scattered, and there doesn't seem to be anything that is different between the ones that won't work versus the one's that do work.
Any ideas on what the problem is?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That worked. I didn't change any of the fields at all. Just changed to it to a .txt tab delimited file and it worked perfectly. I am not sure why it worked, but thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sometimes by mistake there are a few commas left in the columns in the template so when you create a csv file, your columns will be slipped by one and probably the next column in which the value of the original column is displayed now has less characters than the other.
You can try to use VLOOKUP for all the commas in your original template, I'm sure there will be some. If you remove these, the csv file will be imported without problems as well.
Hope it makes sense.
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.