ExcelBanter - dowloading data of CSV file to excel file

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - dowloading data of CSV file to excel file (https://www.excelbanter.com/excel-discussion-misc-queries/258946-dowloading-data-csv-file-excel-file.html)

Igneshwara reddy[_2_]

dowloading data of CSV file to excel file

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

dowloading data of CSV file to excel file

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

Dave Peterson

dowloading data of CSV file to excel file

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

All times are GMT +1. The time now is 01:47 AM.