Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

The maximum characters per row is 65000.

Discussion in 'Information Technology' started by Wayne & Carr, Jul 28, 2006.

  1. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Delhi blasts: Punjab, Haryana on maximum alert (Express India) Breaking News Sep 14, 2008
    Sikh News Punjab, Haryana on maximum alert (The Times of India) Breaking News Sep 13, 2008
    Sikh News Punjab, Haryana on maximum alert (Hindustan Times) Breaking News Sep 13, 2008
    Sikh characters in famous movies Questions and Answers Jul 15, 2014
    Sikh News New Comic Book Coming out With Sikh Characters Breaking News Dec 22, 2005

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    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.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.

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


    --
    Joseph Meehan

    Dia duit
     
  4. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    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. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    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
    Access MVP

    "Wayne & Carr" <noSpam@spam.net> 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
    >
    >
     
  6. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    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
     
  7. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    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.

    --
    Brendan Reynolds
    Access MVP

    "Wayne & Carr" <noSpam@spam.net> 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
    >
    >
     

Share This Page