Help with 65536 macro

  • Thread starter Thread starter kevinz
  • Start date Start date
K

kevinz

Ok, I know excel has the 65536 limit.. but found the code that I guess
will split files up for you. Problem is, I cannot figure out how to get
to work.

Could anyone explain how to do that? I have a more than a few files I
would like to load in excel and are way more than 65k.. This would be a
life saver.

Thank you so much
 
What type of files are they? Text Files? XLS Files? Why load into excel?
Give example of file size. and maybe the code you describe...
 
They are text files, but delimited with commas.. I need to load the
into excel because I need to remove some of those fields and add som
new fields. It makes it easy for me in excel, but I have a couple o
files that just grew too big.. Couple over 100,000 and 200,00
 
Try

Data > import data


What you really need is to import the first 60,000 lines, then import the
next 60,000 lines.
 
With the Data Import Wizard you can specify to start importing at a
particular row. However, the maximum this can be is 32k (32768), so
this allows you to import up to 96k records in two passes - the first
pass will get the first 64k rows and the second pass will get 32k -
96k. You thus have the rows 32k-64k in both worksheets, and you will
need to delete the duplicates.

If you have files with over 96k records you will need a different
strategy - you could load the file into Access and then split it from
there into Excel-sized chunks, or try the same with Wordpad, or you
could use Quattro Pro or Lotus which will accommodate up to 1,000,000
rows.

Alternatively still, Microsoft posted a macro to work on large files
and automatically split them into 64k sheets - I don't have the
reference myself, but you could search their Knowledge Base articles.

Hope this helps.

Pete
 
The code works as per the attached

You will need to highlight Column A and select Data, Text-to-Column
for your data.


Pete, that was my problem.. I found the microsoft macro that is suppos
to split it up. I am just unsure how to use it

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596

It gives you the code, but I just can't get it to work. Little los
using it
Click to expand...

+-------------------------------------------------------------------
|Filename: Book2.zip
|Download: http://www.excelforum.com/attachment.php?postid=4563
+-------------------------------------------------------------------
 
Back
Top