LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2005)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 30 Nov 2005 11:42:52 -0600
Reply-To:     "Oliver, Richard" <roliver@SPSS.COM>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Oliver, Richard" <roliver@SPSS.COM>
Subject:      Re: review Excell and SPSS
Comments: To: Samir OmeroviŠ <samir.omerovic@gfk.ba>
Content-Type: text/plain; charset="iso-8859-2"

AFAIK, you shouldn't need to do anything special for the Excel DAC to work. Have you tried uninstalling and reinstalling SPSS? If that doesn't work, then either try using the Database Wizard approach to read the Excel file or save the Excel file as as tab-delimited or CSV text file and use the Text Wizard to read the text data file.

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Samir Omerovic Sent: Wednesday, November 30, 2005 10:26 AM To: SPSSX-L@LISTSERV.UGA.EDU Subject: review Excell and SPSS

OK, thanks all...

Here is some more data on my problem.

I use SPSS 12 and Excel 2003. I have tried OPN DATA .EXL but something is wrong and it says that Excel DAX mode is not working. I have tried to copy all values from excel to spss but it seems that somewher along the file data gets mixed. And I am sure it is not in excel since I have checked it many times. What I do get in SPSS is ok until it reaches certain case and then the whole file, the variables, is moved to the right by one variable. I have find the specific case in excel and I can not find any strange characters in it. I have removed all the special characters we use in Bosnia so there are only english alphabet characters left.

Hope this puts some light on the problem. I think the problem is in Excel since COPY PASTE always worked before so maybe this is not a appropriate forum I am supposed to bother with this question but there may be someone who had similiar problem.

Anyway thanks.

Samir

GfK BH Centar za istrazivanje trzista i javnog mnijenja d.o.o.

Samir OmeroviŠ Researcher

71 000 Sarajevo, Skenderija 44 Bosna i Hercegovina

Tel: +387 33 550 300 Fax: +387 33 444 226 www.gfk.ba www.gfk.com

---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ------ This e-mail (and any attachment/s) contains confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Ova e-poruka sadrzi povjerljive i/ili povlastene podatke. Ako niste osoba naznacena kao primalac molimo odmah upozoriti posiljaoca i unistiti primljenu e-poruku. Neautorizirano kopiranje, objavljivanje ili distribucija sadrzaja e-poruke striktno je zabranjeno. ---------------------------------------------------------------------------- ----


Back to: Top of message | Previous page | Main SPSSX-L page