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


--
kevinz
------------------------------------------------------------------------
kevinz's Profile: http://www.excelforum.com/member.php...o&userid=32759
View this thread: http://www.excelforum.com/showthread...hreadid=527367

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...

"kevinz" wrote:


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


--
kevinz
------------------------------------------------------------------------
kevinz's Profile: http://www.excelforum.com/member.php...o&userid=32759
View this thread: http://www.excelforum.com/showthread...hreadid=527367

They are text files, but delimited with commas.. I need to load them
into excel because I need to remove some of those fields and add some
new fields. It makes it easy for me in excel, but I have a couple of
files that just grew too big.. Couple over 100,000 and 200,000


--
kevinz
------------------------------------------------------------------------
kevinz's Profile: http://www.excelforum.com/member.php...o&userid=32759
View this thread: http://www.excelforum.com/showthread...hreadid=527367

Try

Data import data


What you really need is to import the first 60,000 lines, then import the
next 60,000 lines.







They are text files, but delimited with commas.. I need to load them
into excel because I need to remove some of those fields and add some
new fields. It makes it easy for me in excel, but I have a couple of
files that just grew too big.. Couple over 100,000 and 200,000


--
kevinz
------------------------------------------------------------------------
kevinz's Profile: http://www.excelforum.com/member.php...o&userid=32759
View this thread: http://www.excelforum.com/showthread...hreadid=527367

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

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

http://support.microsoft.com/default...;en-us;Q120596

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


--
kevinz
------------------------------------------------------------------------
kevinz's Profile: http://www.excelforum.com/member.php...o&userid=32759
View this thread: http://www.excelforum.com/showthread...hreadid=527367

The code works as per the attached

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



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

http://support.microsoft.com/default...;en-us;Q120596

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


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

--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=527367