too many characters to import

S

sveeragandh

I am using 'import text wizard' to import data in .txt file to access.
when I am using this option I am getting below error message

'one or more rows of data in your file contain too many characters to
import. The maximum characters per row is 65000.'

Can any one help to solve this issue.
 
J

Jerry Whittle

I'd open up the text file in something like Word to see if Access is right
about the row length. Select the Show/Hide button so that you can see things
like paragraph marks and spaces. It might be something as simple as replacing
the end of line character from something like ^l (lower case L) to ^p in
Word then saving it as a text file.
 
Top