Hi xs,

Here is an article, with source code, in C#

http://www.c-sharpcorner.com/Code/20...essExcelDb.asp

Best regards,

Chris

"Chris" wrote in message
...
Hi xs,

It looks like ADO is going to be faster.

I found something that might help: http://snipurl.com/OpenExcelFiles Here
it shows ADO being used to access all the Excel files in a directory and
subdirectories.

Also see:

How To Use ADO with Excel Data from Visual Basic or VBA This article
discusses the use of ActiveX Data Objects (ADO) with Microsoft Excel
spreadsheets as a data source. The article also highlights syntax issues
...
http://support.microsoft.com/kb/257819

Hope this information helps,

Chris

"xs" wrote in message
...
Hi,

I tried opening 50+ files using the Open method at theWorkbook class at
one go. However due to the size of each file, which average about 2 MB,
the process takes too long to open. Is there a more efficient way to open
these files? Because each file takes about 5 mins to process and open. I
have tried opening a file, process it and closing it. But it doesn't make
any difference. Is there a way to open 1 excel process and use that
process to open the rest of the excel files? That should be the best way
to open and process them right?

Regards
xs