Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Major help needed
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Then help needed | New Users to Excel | |||
Excel formula needed to amounts into one column pulling from 2 col | Excel Worksheet Functions | |||
Formula Advice Needed | Excel Discussion (Misc queries) | |||
Sumproduct help needed! | Excel Worksheet Functions | |||
Help Needed With - If-Function | Excel Worksheet Functions |