Prev: Sharing Violation
Next: Formating tenths and hundreds to show as whole numbers
From: Igneshwara reddy on 15 Mar 2010 14:45
Hi,

I have the CSV file with more that 200000 lines and I need to import it into
the excel sheet. I have tried using Import wizard and it did not work. I am
using the Excel 2003.

Please let me know the other way I can import the complete data to the excel.

Regards,
Igneshwara Reddy
From: Dave Peterson on 15 Mar 2010 14:50
xl2003 only has 64k rows in a worksheet.

Maybe you could use your favorite text editor and split your file into 3 smaller
pieces. And then import each piece into its own sheet????

Igneshwara reddy wrote:
>
> Hi,
>
> I have the CSV file with more that 200000 lines and I need to import it into
> the excel sheet. I have tried using Import wizard and it did not work. I am
> using the Excel 2003.
>
> Please let me know the other way I can import the complete data to the excel.
>
> Regards,
> Igneshwara Reddy

--

Dave Peterson
From: Dave Peterson on 15 Mar 2010 14:50
ps. xl2007 has 1 meg of rows per worksheet.

Igneshwara reddy wrote:
>
> Hi,
>
> I have the CSV file with more that 200000 lines and I need to import it into
> the excel sheet. I have tried using Import wizard and it did not work. I am
> using the Excel 2003.
>
> Please let me know the other way I can import the complete data to the excel.
>
> Regards,
> Igneshwara Reddy

--

Dave Peterson
 | 
Pages: 1
Prev: Sharing Violation
Next: Formating tenths and hundreds to show as whole numbers