Data for Source Column 15 'Notes' is too large for the specified buffer size.
How do I get around this, I can see some of the notes entries are beyond 255 chars so I changed the destination datatype totext
I have never seen this error when importing before. What do I do?
An error I've gotten way too much. Some things you can try:
- The Excel provider (JET) often makes assumptions based on the first 8 lines of the file, and sometimes that is the problem).
- Or you can save to comma separated or tab separated file format, and import that way.
Oftentimes, I cannot figure out the problem as well. I've tried posting before, but no answer. The only thing I come up with is to save to tab-delimited, and import that way.
Sorry I can't be more help; hopefully someone has the answer.
No comments:
Post a Comment