Want to ask for leave,
In ADO form called Excel file.
Have two vb6 compiled software, A used to input information to the List. The XLSX, B used to read data in the excel table search.
Operating A input information only 2 or 3 people, but there are more than 500 people with B to retrieve data.
List. XLSX several sheet inside pages, each page a few thousand to tens of thousands of lines of text information, dozens of a few columns.
This case, if more than 500 people a day at the same time with the software in the List. B will search data in XLSX everyone wait for a long time? Every time in about ten seconds? Or a few minutes?

2. If waiting for a long time, to save the information in each row in a TXT documents, also is to make a list. The XLSX into tens of thousands of TXT documents,
More than 500 people at the same time with B software to retrieve these TXT documents time will be a lot faster, retrieve a few seconds to get wow?

Please help solve, thank you very much.