Import data more than 65536 row

[psrs0810]

I have a file that I need to import that is more than 65536 rows. I saw the message about re-importing the data to another sheet a second time and select exclude data already imported. How and where do I do this?

or is there a way to import and have the file be over 100000 rows?

I am working with excel 2007 - thanks

 

[VoG]

In Excel 2007 you have over a million rows.

Make sure the file format is .xlsx or .xlsm

 

[Andrew Poulsom]

If you have Excel 2007 you have 1048576 rows.

 

[psrs0810]

the file I am trying to import is a .csv

 

[VoG]

This may help you http://www.cpearson.com/excel/ImportBigFiles.aspx

 

[psrs0810]

Is there another way other than VBA?

when I open my excel it defaults to 65536 rows. Is there a way I can change that?

 

[VoG]

Click the Office Button (top left), click Excel Options. Change the default file format to .xlsx or .xlsm. Click OK. Close Excel then restart it.

 

[psrs0810]

perfect - thank you