Loading 14m records into Excel via .txt file

[fallof89]

What would be the best method of loading a .txt file with 14 million records into 1 spreadsheet? Is this possible? If not, what are my best alternative methods that you all would suggest?

Thanks for your help!

 

[S.H.A.D.O.]

That is a lot of records, and would make quite a big file. What are the records and why has it got to be in a single WorkSheet?

 

[fallof89]

Work records. So, sounds like I need to have it split between multiple worksheets? What would you suggest.

 

[mrlemmer11]

How many columns of data per row are you capturing? I mean, technically you can always just split the data among 10 columns (10 * 1.5 mil rows = 15 mil records). I mean, I would still prefer it to be split across multiple sheets or books personally, but that is a way which you can have 14 mil records in one worksheet.

 

[S.H.A.D.O.]

Work records. So, sounds like I need to have it split between multiple worksheets?

Before you can decide how you are going to put all the records into the WorkBook, you need to decide what you are going to do with the data after it is in there. This will be paramount to how you go about this in the first place.

I hope this helps!

 

[fallof89]

There are 9 columns in each row and the records are dated. So, I'm trying to find the best possible solution to break up the records and still have it orderly, perhaps by week. Which still would be about 3-4m records by week. I could even do it by day, but this would be annoying. But what part of 14m records isn't annoying, right? lol

 

[S.H.A.D.O.]

Would Access not be better for something like this, then you could do whatever you wanted to do with the data?

 

[fallof89]

To be honest, I haven't used Access before. Would you be willing to give me a few steps on how this is done?

 

[S.H.A.D.O.]

To be honest, I haven't used Access before. Would you be willing to give me a few steps on how this is done?

Access is not something you want to start using if you are not familiar with it, I didn't know that until you have just mentioned it. If you did want to go down that route then an Access forum would be your best bet.

Anyway, let's see if we can achieve this using Excel first!

As I said above...

Before you can decide how you are going to put all the records into the WorkBook, you need to decide what you are going to do with the data after it is in there. This will be paramount to how you go about this in the first place.

 

[Kenneth Hobson]

I would agree, Access is what you should pursue as a minimum. You should ask Access questions in a Access forum. A manual import should suffice.

Of course there is always google. Let me google that for you