Single Access database vs. 1,000 Excel files"

[mdarby]

I have written an Excel VBA application which stores the data for a large number of stocks, using a separate .xls file for each stock. I don't know Access well and am wondering if there would be a large performance improvement in storing all that stock data in Access instead of Excel.

Specifically, if I have a worksheet in Excel which repeatedly reads information from 1000 separate, closed .xls file, would I see a big performance improvement if I stored all that information in Access? I am identifying the cells of interest in the Excel files using the MATCH function. I presume I'd identify the records in Access using some kind of query.

THANKS FOR YOUR HELP.

 

[dk]

Hi,

You've already received 2 replies to your duplicate post from earlier on the 1st December and BEFORE you posted this message. If the answer's were not satisfactory please post back in the same thread, and if necessary explain a bit more about your problem.

There's also a duplicate here which hopefully some kind moderator will delete/lock.

 

[NateO]

Please continue the same thread within a single thread. It's confusing to others and possibly yourself to carry on a single discussion in a variety of threads.

Thanks Dan, and thanks for stating why you reported the thread and mentioning the third.