cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting cube data to Excell file

Former Member
0 Kudos

hi Experts,

i want to export the data from cube which has more than 1 lakh.How it stores in Excel file it aloows max 65000 records for each sheet.how can we able to send to another sheet the remaining data.Iam exporting from Manage cube.

bye

venkat

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

No worries ,after 65000 , excel is programmed to store the remaining records in the nxt sheet.

Regards ---Sarvepalli

Former Member
0 Kudos

hi,

it is not writing to next sheet.

hw it writes whether we have to write any program.

bye

venkat

Former Member
0 Kudos

Hi,

its not like that excel will show you only 65k lines, you can just export the file into excel and open it in editor or import it into access and work on it. but dont open file in excel and save it, it will save only 65k lines only.

Regards

Sankar

Former Member
0 Kudos

hi,

is it possible to send to next sheet.

bye

venkat

Former Member
0 Kudos

Hi Venkat,

I think you can export the file as .txt and then import it into MS Access for easy viewing. I am not sure if there is a way to export the file directly to MS Access.

Hope this helps,

Juice

Former Member
0 Kudos

hi,

is it possible to send to next sheet.

bye

venkat