(Msg. 1) Posted: Fri Oct 10, 2008 9:34 pm
Post subject: Exporting to excel from NotePad Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Dear all
I have data that is more than 65k in notepad.Now i want to Export this data
in excel, But when i Export this data it show the message (DATA OVERLOAD).
Is it possible to export data in one sheet1 and remaining data in Sheet2
(Msg. 2) Posted: Sat Oct 11, 2008 8:28 am
Post subject: RE: Exporting to excel from NotePad [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
One way is to split your notepad file into two or more as required.
Is 65K the size or number of rows in your notepad file?
You can also copy a part and paste it in Excel and then convert via
Data|Text to Columns...
Excel version? Excel 2007 does not have this limitation.
"Hardeep_kanwar" wrote:
> Dear all
>
> I have data that is more than 65k in notepad.Now i want to Export this data
> in excel, But when i Export this data it show the message (DATA OVERLOAD).
>
> Is it possible to export data in one sheet1 and remaining data in Sheet2
>
>
> Any help will be Appriciate
>
> Thanks in Advance
(Msg. 3) Posted: Sat Oct 11, 2008 3:40 pm
Post subject: Re: Exporting to excel from NotePad [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You don't have to copy, when you open the text file the text import wizard
will open and it is the same as the data text to columns. In that wizard you
can set it to start importing at row 65536 for the second part. It is not
necessary to copy and paste or to split the
text file itself. Just import as much as you can then in the second batch
(next sheet)import from the last row plus 1 that was imported in the first
batch
--
Regards,
Peo Sjoblom
"Sheeloo" wrote in message
> One way is to split your notepad file into two or more as required.
>
> Is 65K the size or number of rows in your notepad file?
> You can also copy a part and paste it in Excel and then convert via
> Data|Text to Columns...
>
> Excel version? Excel 2007 does not have this limitation.
>
>
> "Hardeep_kanwar" wrote:
>
>> Dear all
>>
>> I have data that is more than 65k in notepad.Now i want to Export this
>> data
>> in excel, But when i Export this data it show the message (DATA
>> OVERLOAD).
>>
>> Is it possible to export data in one sheet1 and remaining data in Sheet2
>>
>>
>> Any help will be Appriciate
>>
>> Thanks in Advance
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in
Office