The maximum characters per row is 65000.

[Wayne & Carr]

Hello All;

I am using Access 2000.
Last night I went to [Import] a .txt file into Access and received
The following error:
=======================================================
One or more rows of data in your file contain too many characters to import.
The maximum characters per row is 65000.
=======================================================

I visited the following page:
http://support.microsoft.com/Default.aspx?scid=kb;en-us;872914&spid=2509&sid=50

And am in the process of following the direction, but am a little confused
On 2-area's.
=======================================================
strOrigFile = "<Full path of your original text file>"
strNewFile = "<Full path of the new text file>"
=======================================================
The above 2-Fields.
What text files is this referring too?
Is it the text files that I am trying to [Import] into Access?
Or is this another type of Text file?

Could someone please collaborate on this a little more?

Thank you All;
Wayne

 

[Joseph Meehan]

Hello All;

I am using Access 2000.
Last night I went to [Import] a .txt file into Access and received
The following error:
=======================================================
One or more rows of data in your file contain too many characters to
import. The maximum characters per row is 65000.
=======================================================

I visited the following page:
http://support.microsoft.com/Default.aspx?scid=kb;en-us;872914&spid=2509&sid=50

And am in the process of following the direction, but am a little
confused On 2-area's.
=======================================================
strOrigFile = "<Full path of your original text file>"
strNewFile = "<Full path of the new text file>"
=======================================================
The above 2-Fields.
What text files is this referring too?
Is it the text files that I am trying to [Import] into Access?
Or is this another type of Text file?

I have never experienced that error message but it appears to be
referring to the text files you are import.

 

[Joseph Meehan]

Hello All;

I am using Access 2000.
Last night I went to [Import] a .txt file into Access and received
The following error:
=======================================================
One or more rows of data in your file contain too many characters to
import. The maximum characters per row is 65000.
=======================================================

I visited the following page:
http://support.microsoft.com/Default.aspx?scid=kb;en-us;872914&spid=2509&sid=50

And am in the process of following the direction, but am a little
confused On 2-area's.
=======================================================
strOrigFile = "<Full path of your original text file>"
strNewFile = "<Full path of the new text file>"
=======================================================
The above 2-Fields.
What text files is this referring too?
Is it the text files that I am trying to [Import] into Access?
Or is this another type of Text file?

I have never experienced that error message but it appears to be
referring to the text files you are import.

 

[Wayne & Carr]

It seems that there was some problems with my Imported Text File
That was throwing up this Error.
But just in case I do hit this limit.
Any and all information that anyone can assist me with will be great.

Thank You
Wayne

 

[Wayne & Carr]

It seems that there was some problems with my Imported Text File
That was throwing up this Error.
But just in case I do hit this limit.
Any and all information that anyone can assist me with will be great.

Thank You
Wayne

 

[Brendan Reynolds]

The code in the article copies the text from the original file to a new
file, replacing Null values with blank spaces in the new file. The variable
'strOrigFile' should point to the original file, the variable 'strNewFile'
should identify the name and location for the new file which the code will
create and to which the changed data (with Null values replaced by spaces)
will be written. After executing the code, you should then hopefully be able
to import from the new file.

Of course, this would only help if the problem was actually caused by Null
values in the text file in the first place. If the problem really was caused
by having more than 65,000 characters per line in the file, you could use
code, somewhat similar to the code in the article, to copy the data from the
original text file to two new ones, dividing the original single lines into
two shorter ones, one in each file.

Of course, if you were going to have to write code like that to get the
import wizard to work, you might be as well off by-passing the wizard
altogether and writing your own import code.

 

[Brendan Reynolds]

The code in the article copies the text from the original file to a new
file, replacing Null values with blank spaces in the new file. The variable
'strOrigFile' should point to the original file, the variable 'strNewFile'
should identify the name and location for the new file which the code will
create and to which the changed data (with Null values replaced by spaces)
will be written. After executing the code, you should then hopefully be able
to import from the new file.

Of course, this would only help if the problem was actually caused by Null
values in the text file in the first place. If the problem really was caused
by having more than 65,000 characters per line in the file, you could use
code, somewhat similar to the code in the article, to copy the data from the
original text file to two new ones, dividing the original single lines into
two shorter ones, one in each file.

Of course, if you were going to have to write code like that to get the
import wizard to work, you might be as well off by-passing the wizard
altogether and writing your own import code.

 

[Wayne & Carr]

Thank you :"Brendan Reynolds";

Great information.
Where is the Old Files usually located? I know in the install directory, but
were at exactly?

And I corrected my issue, it was bad data in the file that was causes some
lines to go together causes the Error to accure.

Thank you once again.
Wayne

 

[Brendan Reynolds]

I'm not sure I understand the question, Wayne. As far as I am aware the only
files we have discussed are the original text file and the new, modified
file that would be created by the code in the KB article. Either of those
files can be in any location, provided of course that they are in a location
to which the user has access and the necessary permissions, that is to say
read permission on the source file and write permission on the target
folder.