Guest T. Valko Posted June 24, 2008 Posted June 24, 2008 Hi Folks! From within Excel I generate simple text files (*.txt) and name them in sequence: File1.txt, File2.txt, File3.txt, etc, etc. The average size of one of these files is about 210 bytes. I need to generate "a lot" of these files. Specifically, I need 2622 of these text files. My question is: can I put all 2622 of these files in a single directory? What's the max size of a directory? I haven't tried it yet. If I can do this it will make my life much easier! -- Biff Microsoft Excel MVP
Guest Pegasus \(MVP\) Posted June 24, 2008 Posted June 24, 2008 Re: Max size of a directory "T. Valko" <biffinpitt@comcast.net> wrote in message news:e0r8oYi1IHA.5832@TK2MSFTNGP02.phx.gbl... > Hi Folks! > > From within Excel I generate simple text files (*.txt) and name them in > sequence: File1.txt, File2.txt, File3.txt, etc, etc. > > The average size of one of these files is about 210 bytes. > > I need to generate "a lot" of these files. Specifically, I need 2622 of > these text files. > > My question is: can I put all 2622 of these files in a single directory? > > What's the max size of a directory? > > I haven't tried it yet. If I can do this it will make my life much easier! > > -- > Biff > Microsoft Excel MVP Yes, you can put all 2622 files into one folder. The limit is "zillions" but file access will slow down to a crawl after a few 100,000 files. For best speed I would not go above 10,000 files per folder.
Guest Terry R. Posted June 24, 2008 Posted June 24, 2008 Re: Max size of a directory The date and time was 6/24/2008 11:14 AM, and on a whim, T. Valko pounded out on the keyboard: > Hi Folks! > > From within Excel I generate simple text files (*.txt) and name them in > sequence: File1.txt, File2.txt, File3.txt, etc, etc. > > The average size of one of these files is about 210 bytes. > > I need to generate "a lot" of these files. Specifically, I need 2622 of > these text files. > > My question is: can I put all 2622 of these files in a single directory? > > What's the max size of a directory? > > I haven't tried it yet. If I can do this it will make my life much easier! > If your disk if formatted using NTFS, you won't hit the a limit. FAT32 had about 65k per. A different limit is how bogged down Windows Explorer gets. The more files in the directory, the longer it takes for Explorer to open. Get too many, and Explorer will crash. -- Terry R. ***Reply Note*** Anti-spam measures are included in my email address. Delete NOSPAM from the email address after clicking Reply.
Guest T. Valko Posted June 24, 2008 Posted June 24, 2008 Re: Max size of a directory Pegasus (MVP)" <I.can@fly.com.oz> wrote in message news:%23RsF$ji1IHA.5472@TK2MSFTNGP06.phx.gbl... > > "T. Valko" <biffinpitt@comcast.net> wrote in message > news:e0r8oYi1IHA.5832@TK2MSFTNGP02.phx.gbl... >> Hi Folks! >> >> From within Excel I generate simple text files (*.txt) and name them in >> sequence: File1.txt, File2.txt, File3.txt, etc, etc. >> >> The average size of one of these files is about 210 bytes. >> >> I need to generate "a lot" of these files. Specifically, I need 2622 of >> these text files. >> >> My question is: can I put all 2622 of these files in a single directory? >> >> What's the max size of a directory? >> >> I haven't tried it yet. If I can do this it will make my life much >> easier! >> >> -- >> Biff >> Microsoft Excel MVP > > Yes, you can put all 2622 files into one folder. The limit > is "zillions" but file access will slow down to a crawl after > a few 100,000 files. For best speed I would not go above > 10,000 files per folder. > Great! This will save me from a ton of tedious, monotonus work. Now I can just click a button and be done. Thanks!
Guest T. Valko Posted June 24, 2008 Posted June 24, 2008 Re: Max size of a directory "Terry R." <F1Com@NOSPAMpobox.com> wrote in message news:O$ktnni1IHA.1628@TK2MSFTNGP03.phx.gbl... > The date and time was 6/24/2008 11:14 AM, and on a whim, T. Valko pounded > out on the keyboard: > >> Hi Folks! >> >> From within Excel I generate simple text files (*.txt) and name them in >> sequence: File1.txt, File2.txt, File3.txt, etc, etc. >> >> The average size of one of these files is about 210 bytes. >> >> I need to generate "a lot" of these files. Specifically, I need 2622 of >> these text files. >> >> My question is: can I put all 2622 of these files in a single directory? >> >> What's the max size of a directory? >> >> I haven't tried it yet. If I can do this it will make my life much >> easier! >> > > If your disk if formatted using NTFS, you won't hit the a limit. FAT32 > had about 65k per. > > A different limit is how bogged down Windows Explorer gets. The more files > in the directory, the longer it takes for Explorer to open. Get too many, > and Explorer will crash. > > -- > Terry R. > > ***Reply Note*** > Anti-spam measures are included in my email address. > Delete NOSPAM from the email address after clicking Reply. The number of files will never exceed 2622. So I should be good to go! Thanks! -- Biff Microsoft Excel MVP
Guest Tim Slattery Posted June 24, 2008 Posted June 24, 2008 Re: Max size of a directory "T. Valko" <biffinpitt@comcast.net> wrote: >Hi Folks! > >From within Excel I generate simple text files (*.txt) and name them in >sequence: File1.txt, File2.txt, File3.txt, etc, etc. > >The average size of one of these files is about 210 bytes. > >I need to generate "a lot" of these files. Specifically, I need 2622 of >these text files. > >My question is: can I put all 2622 of these files in a single directory? Yes. >What's the max size of a directory? If FAT32, you can have 64K entries in a directory. A file or subdirectory with a name longer than 8.3 or containing spaces, commas, or other non-standard characters will take from two to thirteen entries (depending on length). In the NTFS system there is no per-directory limit. There is a per-partition limit, but you're not likely to get there. -- Tim Slattery MS MVP(Shell/User) Slattery_T@bls.gov http://members.cox.net/slatteryt
Guest PhilHibbs Posted June 24, 2008 Posted June 24, 2008 Re: Max size of a directory A word of warning to anyone else reading this thread, though, is that with a *very* large number of files (hundreds of thousands, possibly just tens of thousands), you get weird errors when issuing Command Prompt commands in the directory. This is because you get short file names generated that cause a file to match a pattern that it should not if you only consider the long file name. So, if you do "dir 123*", or "del 123*", then you might display or delete some files that do not begin with 123. Phil Hibbs.
Guest Terry R. Posted June 24, 2008 Posted June 24, 2008 Re: Max size of a directory The date and time was 6/24/2008 11:53 AM, and on a whim, T. Valko pounded out on the keyboard: > "Terry R." <F1Com@NOSPAMpobox.com> wrote in message > news:O$ktnni1IHA.1628@TK2MSFTNGP03.phx.gbl... >> The date and time was 6/24/2008 11:14 AM, and on a whim, T. Valko pounded >> out on the keyboard: >> >>> Hi Folks! >>> >>> From within Excel I generate simple text files (*.txt) and name them in >>> sequence: File1.txt, File2.txt, File3.txt, etc, etc. >>> >>> The average size of one of these files is about 210 bytes. >>> >>> I need to generate "a lot" of these files. Specifically, I need 2622 of >>> these text files. >>> >>> My question is: can I put all 2622 of these files in a single directory? >>> >>> What's the max size of a directory? >>> >>> I haven't tried it yet. If I can do this it will make my life much >>> easier! >>> >> If your disk if formatted using NTFS, you won't hit the a limit. FAT32 >> had about 65k per. >> >> A different limit is how bogged down Windows Explorer gets. The more files >> in the directory, the longer it takes for Explorer to open. Get too many, >> and Explorer will crash. >> > > The number of files will never exceed 2622. So I should be good to go! > > Thanks! > Depends on your CPU, RAM, hard disk speed, etc. But I think you should be okay. -- Terry R. ***Reply Note*** Anti-spam measures are included in my email address. Delete NOSPAM from the email address after clicking Reply.
Guest T. Valko Posted June 26, 2008 Posted June 26, 2008 Re: Max size of a directory I still love DOS! -- Biff Microsoft Excel MVP "PhilHibbs" <snarks@gmail.com> wrote in message news:24477087-4951-4948-83e3-1a1ac468e9c6@z72g2000hsb.googlegroups.com... >A word of warning to anyone else reading this thread, though, is that > with a *very* large number of files (hundreds of thousands, possibly > just tens of thousands), you get weird errors when issuing Command > Prompt commands in the directory. This is because you get short file > names generated that cause a file to match a pattern that it should > not if you only consider the long file name. So, if you do "dir 123*", > or "del 123*", then you might display or delete some files that do not > begin with 123. > > Phil Hibbs.
Recommended Posts