View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_8_] Nigel[_8_] is offline
external usenet poster
 
Posts: 172
Default Controlling Text Loading

Sorry, the target references should have been A:C; D:F, G:I etc., No wonder
I need help!!

"Nigel" wrote in message
...
Hi All
I have a fixed width text file which contains three columns of data and up
to 150,000 rows

I wish to read these into a worksheet, parsing the text into three columns
(by specifying each column width), putting the data into columns A:C until

I
reach 50,000. Then loading the next 50,000 rows into columns C:E, the

next
F:H etc., until all rows have been loaded.

Any help greatly appreciated.

Cheers
Nigel




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet

News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000

Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption

=---




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---