Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Size Limitations (Office 2003 SP1)

    I need to combine eight text delimited files into one flat database. I've been looking for the file size limits for Word and WordPad, to determine which will work best. I haven't come up with anything, other than that WordPad doesn't have the same limits as NotePad. Does anyone know where to find this info?

    TIA
    egghead

  2. #2
    Gold Lounger Rebel's Avatar
    Join Date
    Jul 2001
    Location
    Canada
    Posts
    3,024
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: File Size Limitations (Office 2003 SP1)

    See <!mskb=211489>Microsoft Knowledge Base Article 211489<!/mskb>. Applies to Word 2000, 2002, 2003. Haven't been able to find any documentation for WordPad.
    John
    A Child's Mind, Once Stretched by Imagination...
    Never Regains Its Original Dimensions

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: File Size Limitations (Office 2003 SP1)

    When you say "database" do you simply mean a text file?

    And when you say "combine" do you mean "concatenate", i. e. stick all the files together, one after another, without altering the contents?

    If both of these apply, you can simply use the COPY command in a Command Prompt window:

    COPY file1.txt+file2.txt+file3.txt+file4.txt+file5.txt+ file6.txt+file7.txt+file8.txt all8files.txt

    John
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  4. #4
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Size Limitations (Office 2003 SP1)

    Thank you! That's great info. Do you remember what you used for search terms? I didn't come up with anything like this...
    egghead

  5. #5
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Size Limitations (Office 2003 SP1)

    When I say "flat database" I'm just specifying not an Access relational database. More like remaining a .csv or even an Excel file. And I do mean to combine them into one file, or concatenate.

    <hr> COPY file1.txt+file2.txt+file3.txt+file4.txt+file5.txt+ file6.txt+file7.txt+file8.txt all8files.txt <hr>

    Quick questions on the above, as it's a new process for me: is there a space between "copy" and the first file? And after "file8.txt"?
    Is "all8files.txt" where I create my file name?
    The example show ".txt" so then it's associated with Notepad and subject to the file limitations, right? Can I use this process with .rtf or .doc files, too?

    Thanks!
    egghead

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: File Size Limitations (Office 2003 SP1)

    There is a space between Copy and file1.txt, and also a space between file8.txt and all8files.txt. You can replace all8filtes.txt by the path and file name of your choice.

    This process will only work correctly with plain text files, not with .rtf, .doc or .xls files etc. Although the standard association for .txt files is with Notepad, you can view and edit large text files with many text editors, such as WordPad, MS Word etc. You can even change the association of .txt files if you like, so that they are opened automatically in WordPad, for example.

  7. #7
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: File Size Limitations (Office 2003 SP1)

    I can understand not wanting to use Access, but... a single-table database is a "flat" database, and most Office application can extract data from an .MDB file without the user having to have Access, so it's actually not a bad choice for medium-large volumes of data. (But if you don't have Access in the first place, never mind!)

  8. #8
    Gold Lounger Rebel's Avatar
    Join Date
    Jul 2001
    Location
    Canada
    Posts
    3,024
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: File Size Limitations (Office 2003 SP1)

    You're welcome. Searched (advanced) the KB - product: MS Office Word 2003 - for: "file size"
    John
    A Child's Mind, Once Stretched by Imagination...
    Never Regains Its Original Dimensions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •