Hi ,


I need to process data from flat files and popualte data in Excel
workbooks.

The amount of data is huge .

Say I have 5 flat files each with about 10,00,000 records.

I need to read the files and create some (5000 Excel workbooks with the
data).

Using Excel objects slows the application and the processing takes days.

Is there any way to optimise the process.

Any info cud be helpful.

Thanks and Regards,
Shashank



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Shashank,

I guess my question to you would be why are you trying to import this
many records into Excel rather than using a database like Access? Excel is
optimized to perform complex calculations, not store five million data
records.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"shasank shukla" wrote in message
...


Hi ,


I need to process data from flat files and popualte data in Excel
workbooks.

The amount of data is huge .

Say I have 5 flat files each with about 10,00,000 records.

I need to read the files and create some (5000 Excel workbooks with the
data).

Using Excel objects slows the application and the processing takes days.

Is there any way to optimise the process.

Any info cud be helpful.

Thanks and Regards,
Shashank



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!