Hi,

I am trying to import a text file (1.2GB) into PowerPivot. I am not sure how many rows it has, but it has 32 Columns and I am thinking somewhere around 10 milllion rows. I have read all over online about how PowerPivot can take in many more rows than this, ten times as many and more. I have imported many text files into PowerPivot and I have never really had a problem. If I did get a problem I tried importing again and it seemed to work. I have tried to import this file multiple times and I keep getting the same message. I am not sure if it is a problem with my text file or with PowerPivot because it is taking around 40-48 hours to get through about 7 million rows of data importing. When I come in, in the morning 2 days later is says "Memory error: Allocation failure : Not enough storage is available to process the command. The Operation has been cancelled." I know that this can happen, but from what i have read it should not be happening on such a small file, in PowerPivot's perspective that is. Here are the Specs to my computer.

Windows 7 - 32 Bit
Microsoft office Proffesional 32-Bit
PowerPivot -32Bit
3.0 GB RAM
Intel Core Duo CPU E7500 @ 2.93 GHz

I have heard that 32-bit has limitations on how many rows it can handle, but i cannot believe a file this size, only 1.2GB can take 48 hours to import rows and in the end it doesnt even have the memory to get all of the rows imported.

If anyone has any suggestions on how to increase memory usage or if i should have a 64-bit system, or increasing Processor speed, any help is greatly appretiated.

Thanks