S
shasank shukla
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!
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!