Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default What is the maximum number of files that a directory can contain on Windows XP?

Hi,

We have some external systems that send us data in CSV format.
These CSV files are periodically deposited in a specific directory o
Windows XP server.

Do you know what is the maximum number of files that a directory ca
contain on Windows XP?
What happens when this maximum is reached?
Is there some formal documentation about this - that you can point m
to?

Thank

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default What is the maximum number of files that a directory can contain on Windows XP?

I'd ask this in the appropriate Windows (server) newsgroup.

--
Jim Rech
Excel MVP


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 170
Default What is the maximum number of files that a directory can contain on Windows XP?


"lothario " wrote in message
...
Hi,

We have some external systems that send us data in CSV format.
These CSV files are periodically deposited in a specific directory on
Windows XP server.

Do you know what is the maximum number of files that a directory can
contain on Windows XP?


Depends on the File System

For FAT32 the limits are :
Maximum file size 4 GB minus 1 byte (232 bytes minus 1 byte)
Maximum volume size 32 GB (implementation)
Files per volume 4,177,920
Maximum number of files and subfolders within a single folder 65,534
(The use of long file names can significantly reduce the number of available
files and subfolders within a folder.)

For NTFS
Maximum file size 16 terabytes minus 64 KB (244 bytes minus 64 KB)
Maximum volume size 256 terabytes minus 64 KB ( 232 clusters minus 1
cluster)
Files per volume 4,294,967,295 (232 minus 1 file)
Files Per Folder as per files per volume

NOTE
If you use large numbers of files in an NTFS folder (300,000 or more),
disable short-file
name generation, especially if the first six characters of the long file
names are similar.

What happens when this maximum is reached?


It will throw an exception

Is there some formal documentation about this - that you can point me
to?


http://www.microsoft.com/technet/tre...c_fil_tdrn.asp

Keith


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 PoundMutt Excel Discussion (Misc queries) 1 June 20th 07 03:50 AM
Files in a directory? Greg B Excel Discussion (Misc queries) 5 May 11th 05 09:46 PM
Load all files in a directory Greg B... Excel Discussion (Misc queries) 2 March 2nd 05 12:22 PM
Check if directory empty OR no of files in directory. Michael Beckinsale Excel Programming 2 December 4th 03 10:12 PM
run macro for all files in the directory igor Excel Programming 3 July 17th 03 03:48 PM


All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"