Importing 100,000roes and 13columns into excel

  • Thread starter Thread starter AP
  • Start date Start date
A

AP

Hi all

I now there is a limit of 65k rows in excel and wonder if there is a macro i
can run that parse through the text file that contains 100,000rows and 13
column which are tab delimetd with a | [pipe]

Currently i can run a the following macro
http://support.microsoft.com/kb/120596 and it import all 100,000 and splits
them into 2 workshets on the same excel file, but the column are merge into
1 column and not 13.

I like to stick to excel as i dont have licenses for MS Access or any other
application to import this data.

Any help much appreciated, thanks.
 
After that macro runs, you can select column A in the first worksheet, then do
data|text to columns and use delimited by Other (|).

Then repeat on the second worksheet.
Hi all

I now there is a limit of 65k rows in excel and wonder if there is a macro i
can run that parse through the text file that contains 100,000rows and 13
column which are tab delimetd with a | [pipe]

Currently i can run a the following macro
http://support.microsoft.com/kb/120596 and it import all 100,000 and splits
them into 2 workshets on the same excel file, but the column are merge into
1 column and not 13.

I like to stick to excel as i dont have licenses for MS Access or any other
application to import this data.

Any help much appreciated, thanks.
Click to expand...
 
Hi

On the MS website where the code is posted, it says after the code

Note The macro does not parse the data into columns. After using the macro,
you may also need to use the Text To Columns command on the Data menu to
parse the data as needed.

Select Column A>Data>Text to Columns and choose the appropriate delimiter
for your situation.
 
Thank you all.
I will give this a try.

Roger Govier said:
Hi

On the MS website where the code is posted, it says after the code

Note The macro does not parse the data into columns. After using the
macro, you may also need to use the Text To Columns command on the Data
menu to parse the data as needed.

Select Column A>Data>Text to Columns and choose the appropriate delimiter
for your situation.
--
Regards
Roger Govier



AP said:
Hi all

I now there is a limit of 65k rows in excel and wonder if there is a
macro i can run that parse through the text file that contains
100,000rows and 13 column which are tab delimetd with a | [pipe]

Currently i can run a the following macro
http://support.microsoft.com/kb/120596 and it import all 100,000 and
splits them into 2 workshets on the same excel file, but the column are
merge into 1 column and not 13.

I like to stick to excel as i dont have licenses for MS Access or any
other application to import this data.

Any help much appreciated, thanks.
Click to expand...
Click to expand...
 
Back
Top