The maximum characters per row is 65000.

#1 (**permalink**) 28-Jul-2006, 08:11 AM

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...id=2509&sid=50
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10216-the-maximum-characters-per-row-65000-a.html

And am in the process of following the direction, but am a little confused
On 2-area's.
================================================== =====
strOrigFile = ""
strNewFile = ""
================================================== =====
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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216

Could someone please collaborate on this a little more?

Thank you All;
Wayne

#2 (**permalink**) 28-Jul-2006, 08:11 AM

Wayne & Carr wrote:
> 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...id=2509&sid=50
>
> And am in the process of following the direction, but am a little
> confused On 2-area's.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
> ================================================== =====
> strOrigFile = ""
> strNewFile = ""
> ================================================== =====
> The above 2-Fields.
> What text files is this referring too?
> Is it the text files that I am trying to [Import] into Access?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
> 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.

>
> Could someone please collaborate on this a little more?
>
> Thank you All;
> Wayne

--
Joseph Meehan

Dia duit

#3 (**permalink**) 28-Jul-2006, 08:11 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
Any and all information that anyone can assist me with will be great.

Thank You
Wayne

#4 (**permalink**) 28-Jul-2006, 08:11 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
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
Access MVP

"Wayne & Carr" wrote in message
news:eNL7gVzfGHA.3652@TK2MSFTNGP02.phx.gbl...
> 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
>
>

#5 (**permalink**) 28-Jul-2006, 08:12 AM

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.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
Thank you once again.
Wayne

#6 (**permalink**) 28-Jul-2006, 08:12 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
read permission on the source file and write permission on the target
folder.

--
Brendan Reynolds
Access MVP

"Wayne & Carr" wrote in message
news:O0sMKkEgGHA.3652@TK2MSFTNGP02.phx.gbl...
> 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
>
>