dowloading data of CSV file to excel file

I

Igneshwara reddy

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
 
D

Dave Peterson

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????
 
D

Dave Peterson

ps. xl2007 has 1 meg of rows per worksheet.

Igneshwara said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Multiple CSV Files from Same Folder into Open Workbook 5
Import more than one .csv file into the same Excel file. 1
Excel CSV Files; Creating Of 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How to save files in the formats of *.csv(MS-DOS) in Excel 2003 2
csv, how to set excel to auto load 5
CSV->Excel Data Problem 1
CSV File Will Not Open Directly in Excel 2003 4

Top