Hi,
I am trying to import a large file into excel. The file is approx 100,000 lines and is divided into 7 columns by commas. It is an *.asc file.
Is there any more efficient way of importing it besides using TextStream, importing about 10,000 lines and then using Text to Columns, putting the data in an array, then going to the next 10K? This way takes about 2min/100K lines.
I have also tried using Data -> Import External Data -> and then opening the file. Using this, you can set a row to start importing on but the problem is it only goes up to 32,000. My files have over 100K lines and the last rows are cut off this way.
Are there any other ways to import the data to excel?
Your help will be much appreciated.
Thanks.
I am trying to import a large file into excel. The file is approx 100,000 lines and is divided into 7 columns by commas. It is an *.asc file.
Is there any more efficient way of importing it besides using TextStream, importing about 10,000 lines and then using Text to Columns, putting the data in an array, then going to the next 10K? This way takes about 2min/100K lines.
I have also tried using Data -> Import External Data -> and then opening the file. Using this, you can set a row to start importing on but the problem is it only goes up to 32,000. My files have over 100K lines and the last rows are cut off this way.
Are there any other ways to import the data to excel?
Your help will be much appreciated.
Thanks.