Right, so this one is a biggy for me, and I'm stumped.

Basically, I have to analyse the mobile phone records for my company. The
invoice comes in on a disk, and now it's my job to go through all the calls
picking out certain numbers, users, etc.
Anyway, after exporting the data to a .txt file, i now need to open it in
excel so I can start comparing and so on. Unfortunately, this is a big
company and turns out, there are a lot of calls being made.
So excel is unable to open anything more than the first 65 000 odd rows of
calls. I still need a lot, lot more.
Is there any way that Excel can carry on opening the txt file in another
worksheet or something like that.
For instance, as soon as one worksheet is full, move on to Sheet 2 instead
of just stopping the opening?

If anybody has any ideas they would be greatly appreciated, 'cos there's no
way I'm going through those records manually.

Thanks a lot,
mike

mike, have a look here,

http://redirx.com/?334z


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"mike_vr" wrote in message
...

Right, so this one is a biggy for me, and I'm stumped.

Basically, I have to analyse the mobile phone records for my company. The
invoice comes in on a disk, and now it's my job to go through all the
calls
picking out certain numbers, users, etc.
Anyway, after exporting the data to a .txt file, i now need to open it in
excel so I can start comparing and so on. Unfortunately, this is a big
company and turns out, there are a lot of calls being made.
So excel is unable to open anything more than the first 65 000 odd rows of
calls. I still need a lot, lot more.
Is there any way that Excel can carry on opening the txt file in another
worksheet or something like that.
For instance, as soon as one worksheet is full, move on to Sheet 2 instead
of just stopping the opening?

If anybody has any ideas they would be greatly appreciated, 'cos there's
no
way I'm going through those records manually.

Thanks a lot,
mike

how "clean" is the data in the txt file? Is it a report with page headings,
footers, blank lines, etc? Sometimes it's easier to pull it into a word
processor first and get it down to just rows of the call data, nothing else.

Another suggestion: try to use Access instead of Excel...

Bye

Franz


"Paul B" ha scritto nel messaggio
...
mike, have a look here,

http://redirx.com/?334z


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"mike_vr" wrote in message
...

Right, so this one is a biggy for me, and I'm stumped.

Basically, I have to analyse the mobile phone records for my company. The
invoice comes in on a disk, and now it's my job to go through all the
calls
picking out certain numbers, users, etc.
Anyway, after exporting the data to a .txt file, i now need to open it in
excel so I can start comparing and so on. Unfortunately, this is a big
company and turns out, there are a lot of calls being made.
So excel is unable to open anything more than the first 65 000 odd rows
of
calls. I still need a lot, lot more.
Is there any way that Excel can carry on opening the txt file in another
worksheet or something like that.
For instance, as soon as one worksheet is full, move on to Sheet 2
instead
of just stopping the opening?

If anybody has any ideas they would be greatly appreciated, 'cos there's
no
way I'm going through those records manually.

Thanks a lot,
mike

Surely this is a job for a database?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mike_vr" wrote in message
...
Right, so this one is a biggy for me, and I'm stumped.

Basically, I have to analyse the mobile phone records for my company. The
invoice comes in on a disk, and now it's my job to go through all the
calls
picking out certain numbers, users, etc.
Anyway, after exporting the data to a .txt file, i now need to open it in
excel so I can start comparing and so on. Unfortunately, this is a big
company and turns out, there are a lot of calls being made.
So excel is unable to open anything more than the first 65 000 odd rows of
calls. I still need a lot, lot more.
Is there any way that Excel can carry on opening the txt file in another
worksheet or something like that.
For instance, as soon as one worksheet is full, move on to Sheet 2 instead
of just stopping the opening?

If anybody has any ideas they would be greatly appreciated, 'cos there's
no
way I'm going through those records manually.

Thanks a lot,
mike

Agree 150%.

The couple of hours invested in learning to use the rudimentary features of
Access will be returned many times over in ease of use. Additionally, Excel
can easily query Access tables to pull in specific subsets of data.


"Bob Phillips" wrote:

Surely this is a job for a database?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mike_vr" wrote in message
...
Right, so this one is a biggy for me, and I'm stumped.

Basically, I have to analyse the mobile phone records for my company. The
invoice comes in on a disk, and now it's my job to go through all the
calls
picking out certain numbers, users, etc.
Anyway, after exporting the data to a .txt file, i now need to open it in
excel so I can start comparing and so on. Unfortunately, this is a big
company and turns out, there are a lot of calls being made.
So excel is unable to open anything more than the first 65 000 odd rows of
calls. I still need a lot, lot more.
Is there any way that Excel can carry on opening the txt file in another
worksheet or something like that.
For instance, as soon as one worksheet is full, move on to Sheet 2 instead
of just stopping the opening?

If anybody has any ideas they would be greatly appreciated, 'cos there's
no
way I'm going through those records manually.

Thanks a lot,
mike

Paul you legend, code works brilliantly. only problem is it places all info
in the first cell but that's easily sorted with a quick "text to column".

Nice one mate, thanks

"Paul B" wrote:

mike, have a look here,

http://redirx.com/?334z


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"mike_vr" wrote in message
...

Right, so this one is a biggy for me, and I'm stumped.

Basically, I have to analyse the mobile phone records for my company. The
invoice comes in on a disk, and now it's my job to go through all the
calls
picking out certain numbers, users, etc.
Anyway, after exporting the data to a .txt file, i now need to open it in
excel so I can start comparing and so on. Unfortunately, this is a big
company and turns out, there are a lot of calls being made.
So excel is unable to open anything more than the first 65 000 odd rows of
calls. I still need a lot, lot more.
Is there any way that Excel can carry on opening the txt file in another
worksheet or something like that.
For instance, as soon as one worksheet is full, move on to Sheet 2 instead
of just stopping the opening?

If anybody has any ideas they would be greatly appreciated, 'cos there's
no
way I'm going through those records manually.

Thanks a lot,
mike