Export to Excel Fix
Locked
 
|
Hello all,
I was trying to export a relatively big table from spss output to excel and it didn't go through (spss encountered a problem with a memory...). I searched the web and I found that this is a known issue in SPSS 16.0 and that also that has been fixed with the hotfix 16.0.2. I wanted to check with you, have you experienced this problem and does the fix really work. I bet this topic has already been brought up on this mailing list, but I am new here; actually this is my first message. Thank you in advance, Sandra ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
I was having the same problem (exporting a 16-page long table to
Excel), installed all the patches up to 16.0.2 and the export still failed. After running the 16.0.2.1 hotfix, it finally worked. -Gary On Thu, Jul 24, 2008 at 5:01 PM, Sandra Delova <[hidden email]> wrote: > Hello all, > > I was trying to export a relatively big table from spss output to excel > and it didn't go through (spss encountered a problem with a memory...). > I searched the web and I found that this is a known issue in SPSS 16.0 > and that also that has been fixed with the hotfix 16.0.2. > I wanted to check with you, have you experienced this problem and does > the fix really work. > > I bet this topic has already been brought up on this mailing list, but I > am new here; actually this is my first message. > Thank you in advance, > Sandra > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
Hi y'all:
I had the same problem with SPSS 16, even with the patches and fixes. The table simply would not export to .xls format, with a memory problem notice showing on the screen. Fortunately, the same export worked quite nicely with SPSS 17 (Beta). SPSS 16 had more than a few problems so I'll be glad when SPSS 17 is released in final version. Best wishes. Tom ----- Thomas W. MacFarland, Ed.D. Senior Research Associate; Institutional Effectiveness and Associate Professor Nova Southeastern University Voice 954-262-5395 Fax 954-262-3970 [hidden email] -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Hal 9000 Sent: Friday, July 25, 2008 1:48 AM To: [hidden email] Subject: Re: Export to Excel Fix I was having the same problem (exporting a 16-page long table to Excel), installed all the patches up to 16.0.2 and the export still failed. After running the 16.0.2.1 hotfix, it finally worked. -Gary On Thu, Jul 24, 2008 at 5:01 PM, Sandra Delova <[hidden email]> wrote: > Hello all, > > I was trying to export a relatively big table from spss output to excel > and it didn't go through (spss encountered a problem with a memory...). > I searched the web and I found that this is a known issue in SPSS 16.0 > and that also that has been fixed with the hotfix 16.0.2. > I wanted to check with you, have you experienced this problem and does > the fix really work. > > I bet this topic has already been brought up on this mailing list, but I > am new here; actually this is my first message. > Thank you in advance, > Sandra > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
Hi all,
I am waiting for the hotfix 16.0.2 to be installed on my work machine, I really hope it's gonna work. I will not be able to get SPSS 17 (beta), because of the company policy..So, if it doesn't work, as In Dr. Tomas's case, do you have an idea what can I do? I tried exporting to txt file, didn't work also. Thank you, Sandra On 7/25/08, Dr. Thomas W. MacFarland <[hidden email]> wrote: > > Hi y'all: > > I had the same problem with SPSS 16, even with the patches and fixes. The > table simply would not export to .xls format, with a memory problem notice > showing on the screen. > > Fortunately, the same export worked quite nicely with SPSS 17 (Beta). > > SPSS 16 had more than a few problems so I'll be glad when SPSS 17 is > released in final version. > > Best wishes. > > Tom > > ----- > Thomas W. MacFarland, Ed.D. > Senior Research Associate; Institutional Effectiveness and Associate > Professor > Nova Southeastern University > Voice 954-262-5395 Fax 954-262-3970 [hidden email] > > -----Original Message----- > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of > Hal > 9000 > Sent: Friday, July 25, 2008 1:48 AM > To: [hidden email] > Subject: Re: Export to Excel Fix > > I was having the same problem (exporting a 16-page long table to > Excel), installed all the patches up to 16.0.2 and the export still > failed. After running the 16.0.2.1 hotfix, it finally worked. > > -Gary > > On Thu, Jul 24, 2008 at 5:01 PM, Sandra Delova <[hidden email]> > wrote: > > Hello all, > > > > I was trying to export a relatively big table from spss output to excel > > and it didn't go through (spss encountered a problem with a memory...). > > I searched the web and I found that this is a known issue in SPSS 16.0 > > and that also that has been fixed with the hotfix 16.0.2. > > I wanted to check with you, have you experienced this problem and does > > the fix really work. > > > > I bet this topic has already been brought up on this mailing list, but I > > am new here; actually this is my first message. > > Thank you in advance, > > Sandra > > > > ===================== > > To manage your subscription to SPSSX-L, send a message to > > [hidden email] (not to SPSSX-L), with no body text except the > > command. To leave the list, send the command > > SIGNOFF SPSSX-L > > For a list of commands to manage subscriptions, send the command > > INFO REFCARD > > > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
In reply to this post by Thomas MacFarland
Hi,
Just out of curiosity (I am using v14 or v15 myself): did you try using OMS (--> utilities --> OMS control panel) to export the table to e.g. tabbed text? That might be a work around. Something like the syntax below. Cheers!! Albert-Jan * OMS. OMS /SELECT TABLES /IF COMMANDS = ["Descriptives"] SUBTYPES = ["Descriptive Statistics"] /DESTINATION FORMAT = TABTEXT OUTFILE = "D:\temp\mytable.txt". DESCRIPTIVES VARIABLES=age /STATISTICS=MEAN STDDEV MIN MAX . OMSEND. --- On Fri, 7/25/08, Dr. Thomas W. MacFarland <[hidden email]> wrote: > From: Dr. Thomas W. MacFarland <[hidden email]> > Subject: Re: Export to Excel Fix > To: [hidden email] > Date: Friday, July 25, 2008, 3:06 PM > Hi y'all: > > I had the same problem with SPSS 16, even with the patches > and fixes. The > table simply would not export to .xls format, with a memory > problem notice > showing on the screen. > > Fortunately, the same export worked quite nicely with SPSS > 17 (Beta). > > SPSS 16 had more than a few problems so I'll be glad > when SPSS 17 is > released in final version. > > Best wishes. > > Tom > > ----- > Thomas W. MacFarland, Ed.D. > Senior Research Associate; Institutional Effectiveness and > Associate > Professor > Nova Southeastern University > Voice 954-262-5395 Fax 954-262-3970 [hidden email] > > -----Original Message----- > From: SPSSX(r) Discussion [mailto:[hidden email]] > On Behalf Of Hal > 9000 > Sent: Friday, July 25, 2008 1:48 AM > To: [hidden email] > Subject: Re: Export to Excel Fix > > I was having the same problem (exporting a 16-page long > table to > Excel), installed all the patches up to 16.0.2 and the > export still > failed. After running the 16.0.2.1 hotfix, it finally > worked. > > -Gary > > On Thu, Jul 24, 2008 at 5:01 PM, Sandra Delova > <[hidden email]> > wrote: > > Hello all, > > > > I was trying to export a relatively big table from > spss output to excel > > and it didn't go through (spss encountered a > problem with a memory...). > > I searched the web and I found that this is a known > issue in SPSS 16.0 > > and that also that has been fixed with the hotfix > 16.0.2. > > I wanted to check with you, have you experienced this > problem and does > > the fix really work. > > > > I bet this topic has already been brought up on this > mailing list, but I > > am new here; actually this is my first message. > > Thank you in advance, > > Sandra > > > > ===================== > > To manage your subscription to SPSSX-L, send a message > to > > [hidden email] (not to SPSSX-L), with no > body text except the > > command. To leave the list, send the command > > SIGNOFF SPSSX-L > > For a list of commands to manage subscriptions, send > the command > > INFO REFCARD > > > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body > text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the > command > INFO REFCARD > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body > text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the > command > INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
Thanks to all of you for your help!
The hotfix 16.0.2 did work for me. Albert-Jan, yes, i tried OMS and didn't work either. I also tried some temporary fix that I found on some forum, creating system environment variable called SPSSClientMaxHeapLevel, and set the value to 2 or 3. Someone said that this worked for him, I didn't have luck with that. Thanks again! Enjoy the weekend, Sandra On 7/25/08, Albert-jan Roskam <[hidden email]> wrote: > > Hi, > > Just out of curiosity (I am using v14 or v15 myself): did you try using > OMS (--> utilities --> OMS control panel) to export the table to e.g. > tabbed text? That might be a work around. Something like the syntax below. > > Cheers!! > Albert-Jan > > * OMS. > OMS > /SELECT TABLES > /IF COMMANDS = ["Descriptives"] > SUBTYPES = ["Descriptive Statistics"] > /DESTINATION FORMAT = TABTEXT > OUTFILE = "D:\temp\mytable.txt". > > DESCRIPTIVES > VARIABLES=age > /STATISTICS=MEAN STDDEV MIN MAX . > > OMSEND. > > > --- On Fri, 7/25/08, Dr. Thomas W. MacFarland <[hidden email]> wrote: > > > From: Dr. Thomas W. MacFarland <[hidden email]> > > Subject: Re: Export to Excel Fix > > To: [hidden email] > > Date: Friday, July 25, 2008, 3:06 PM > > Hi y'all: > > > > I had the same problem with SPSS 16, even with the patches > > and fixes. The > > table simply would not export to .xls format, with a memory > > problem notice > > showing on the screen. > > > > Fortunately, the same export worked quite nicely with SPSS > > 17 (Beta). > > > > SPSS 16 had more than a few problems so I'll be glad > > when SPSS 17 is > > released in final version. > > > > Best wishes. > > > > Tom > > > > ----- > > Thomas W. MacFarland, Ed.D. > > Senior Research Associate; Institutional Effectiveness and > > Associate > > Professor > > Nova Southeastern University > > Voice 954-262-5395 Fax 954-262-3970 [hidden email] > > > > -----Original Message----- > > From: SPSSX(r) Discussion [mailto:[hidden email]] > > On Behalf Of Hal > > 9000 > > Sent: Friday, July 25, 2008 1:48 AM > > To: [hidden email] > > Subject: Re: Export to Excel Fix > > > > I was having the same problem (exporting a 16-page long > > table to > > Excel), installed all the patches up to 16.0.2 and the > > export still > > failed. After running the 16.0.2.1 hotfix, it finally > > worked. > > > > -Gary > > > > On Thu, Jul 24, 2008 at 5:01 PM, Sandra Delova > > <[hidden email]> > > wrote: > > > Hello all, > > > > > > I was trying to export a relatively big table from > > spss output to excel > > > and it didn't go through (spss encountered a > > problem with a memory...). > > > I searched the web and I found that this is a known > > issue in SPSS 16.0 > > > and that also that has been fixed with the hotfix > > 16.0.2. > > > I wanted to check with you, have you experienced this > > problem and does > > > the fix really work. > > > > > > I bet this topic has already been brought up on this > > mailing list, but I > > > am new here; actually this is my first message. > > > Thank you in advance, > > > Sandra > > > > > > ===================== > > > To manage your subscription to SPSSX-L, send a message > > to > > > [hidden email] (not to SPSSX-L), with no > > body text except the > > > command. To leave the list, send the command > > > SIGNOFF SPSSX-L > > > For a list of commands to manage subscriptions, send > > the command > > > INFO REFCARD > > > > > > > ===================== > > To manage your subscription to SPSSX-L, send a message to > > [hidden email] (not to SPSSX-L), with no body > > text except the > > command. To leave the list, send the command > > SIGNOFF SPSSX-L > > For a list of commands to manage subscriptions, send the > > command > > INFO REFCARD > > > > ===================== > > To manage your subscription to SPSSX-L, send a message to > > [hidden email] (not to SPSSX-L), with no body > > text except the > > command. To leave the list, send the command > > SIGNOFF SPSSX-L > > For a list of commands to manage subscriptions, send the > > command > > INFO REFCARD > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |