I have a file thats a CSV file, and its more than the max lines allowed on one book on Excel.

How do i get the full file onto 2 wookbooks?

Cheers

Will it open in Notepad? You could split it into two files that way and then import the files individually?

I have no iodea what you're talking about but could this be useful somehow?

CSV file editor, unicode compatible on Windows XP NT 2000

Will it open in Notepad? You could split it into two files that way and then import the files individually?

Failing that Wordpad will open bigger files letting you do the same.

Word even.

As above, notepad or Wordpad.

Agreed. Import what you can, then use Notebook to delete everything down to that point, then import the rest.

Remember to allow space for adding header rows if required.

Thanks!

Ive got a lot of editing etc to do!

12.9K file size!

Not really. I've had to do this before.

When you open the file in Notebook, do ctrl+end to get to the end of it, up arrow key a couple of times, then do ctrl+shift+home to select the rows you want to delete, and press delete. I can do it faster than I can type it!

Openoffice...

Ive used it several times to open and re-save corrupted word/excel documents.

How does that get round the OP's issue, which is importing a valid csv which is over the Excel line limit into Excel and not OpenOffice?

Upgrade to Office 2007 and Excel will allow something like a million columns and rows! :eek:

Not really. I've had to do this before.

When you open the file in Notebook, do ctrl+end to get to the end of it, up arrow key a couple of times, then do ctrl+shift+home to select the rows you want to delete, and press delete. I can do it faster than I can type it!

If you use Ctrl+X instead of Delete, the rows you get rid of will be stored on the clipboard so you won't need to remember where you deleted up to! Then you can just open another Notepad file and Ctrl+V. Don't forget the change the extension to *.csv!

import the csv in to access and output from there.

providing you have access!

Upgrade to Office 2007 and Excel will allow something like a million columns and rows! :eek:

The only way most people see this sort of quantity of data is for work, so they may not have the option of "upgrading" to Office 2007.

Actually, the same argument may well apply to using OpenOffice.

If you use Ctrl+X instead of Delete, the rows you get rid of will be stored on the clipboard so you won't need to remember where you deleted up to! Then you can just open another Notepad file and Ctrl+V. Don't forget the change the extension to *.csv!

Those data are already in Excel. Why, particularly given the existence of the well-known Excel memory leak, would I want to clutter up memory by sticking a copy of it on the Clipboard?

Those data are already in Excel. Why, particularly given the existence of the well-known Excel memory leak, would I want to clutter up memory by sticking a copy of it on the Clipboard?

No they're not?! Cut the last half, say, then save the remainder as a csv file. Open another file, paste the contents of the clipboard into it and savethat as a new csv file. Then import both files into separate worksheets.

Otherwise, if you forget where you've deleted up to, it'll be the well-known User memory leak that'll let you down!

No they're not?! Cut the last half, say, then save the remainder as a csv file. Open another file, paste the contents of the clipboard into it and savethat as a new csv file. Then import both files into separate worksheets.

Otherwise, if you forget where you've deleted up to, it'll be the well-known User memory leak that'll let you down!

Yes they are; the first thing I did was an import, knowing that it would refuse the last (in this case 1) row(s).

Yes they are; the first thing I did was an import, knowing that it would refuse the last (in this case 1) row(s).

Ah, I see. I was editing first and importing later...!