LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Importing large text file ERROR

I think you should have got the message by now that Excel is not the right
tool for your requirements.
Use a (proper) database approach.

NickHK

"J@Y" wrote in message
...
I am importing a large text file into Excel using MS's macro (ie: creating
mulitple worksheets)
After about 1 million lines, I get this error message saying I don't have
enough resources to complete the task. I have about 2 gigs for physiscal
memory and 3 gigs of virtual memory. What exactly is the resources

refering
to?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing and splitting large text file JeffMelton Excel Programming 1 August 29th 06 12:29 AM
Importing a large text file hmm Excel Discussion (Misc queries) 4 March 15th 06 03:13 PM
Importing a large txt file Luis[_6_] Excel Programming 2 June 5th 05 05:03 PM
Excel 2003 Importing large delimited text file Ron[_28_] Excel Programming 2 January 5th 05 02:58 PM
Importing a large text file (65536) Chip Pearson Excel Programming 0 May 18th 04 09:24 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"