SAVE TRANSLATE error

[Mario Giesel]

* Hi, SPSS friends,
  a colleague of mine wants to export sav data to xls sheets via SAVE TRANSLATE;
I did some research and tried Raynald Levesques solution given here:
http://www.spsstools.net/Syntax/Export_Import/ExportSomeSPSSvarsToManySheetsOfExcelWorkbook.txt
However, it doesn't work, as I get an error message that some module has not been found:

>Fehlernummer 6492
>Das ODBC-Subsystem hat einen Fehler ausgegeben, der die Verarbeitung der
>Anforderung SAVE TRANSLATE ODBC verhindert
>Die Ausführung dieses Befehls wurde gestoppt
>Aufgrund des Systemfehlers   126: Das angegebene Modul wurde nicht gefunden
>(Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb),
>C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE15\ACEODBC.DLL) konnte der angegebene
>Treiber nicht geladen werden
>Fehlernummer 6452
>Beim Schreiben der Ausgabedatei ist ein Fehler aufgetreten

My command looks like following; do you know a solution for this?
Thanks for any idea .

SAVE TRANSLATE
 /TYPE=odbc
 /CONNECT="DSN=Excel Files;DBQ=C:\Users\gieselm\Documents\SPSSInc\demo.xls;"
 /TABLE="mySheet1"
 /KEEP= lfdn_neu2 KWJahr MonatJahr QuartalJahr
 /UNSELECTED=retain
 /REPLACE.

===================== 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

[Jignesh Sutar]

Syntax (connect string) looks incomplete, here's a working example:


get file="C:\Program Files\IBM\SPSS\Statistics\23\Samples\English\Employee data.sav".

save translate
    /connect="dsn=excel files;dbq=C:\Temp\EmployeeDataExcelExport.xls;driverid=790;maxbuffersize=2048;pagetimeout=5;"
    /table="EmployeeData"
    /type=odbc /map /replace.

[Anton Balabanov-2]

Hi, Mario,

 

When you use CONNECT="DSN=Excel Files; string, you need Data Source "Excel Files" to be defined in you operation system. It looks like this either not defined or corrupted somehow (could you check if the path aceodbc.dll exists, and if not, possibly, redefine the data source). In Windows this could be done under Control Panel...Administration...ODBC Data Sources (or something similar).

 

Connect string might be extended, as Jignesh suggested, but this version works fine for me also unless I removed Excel DSN from the data sources.

 

Best regards,

Anton Balabanov

 

26.06.2015, 11:05, "Mario Giesel" <[hidden email]>:

* Hi, SPSS friends,
  a colleague of mine wants to export sav data to xls sheets via SAVE TRANSLATE;
I did some research and tried Raynald Levesques solution given here:
http://www.spsstools.net/Syntax/Export_Import/ExportSomeSPSSvarsToManySheetsOfExcelWorkbook.txt
However, it doesn't work, as I get an error message that some module has not been found:

>Fehlernummer 6492
>Das ODBC-Subsystem hat einen Fehler ausgegeben, der die Verarbeitung der
>Anforderung SAVE TRANSLATE ODBC verhindert
>Die Ausführung dieses Befehls wurde gestoppt
>Aufgrund des Systemfehlers   126: Das angegebene Modul wurde nicht gefunden
>(Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb),
>C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE15\ACEODBC.DLL) konnte der angegebene
>Treiber nicht geladen werden
>Fehlernummer 6452
>Beim Schreiben der Ausgabedatei ist ein Fehler aufgetreten

My command looks like following; do you know a solution for this?
Thanks for any idea .

SAVE TRANSLATE
 /TYPE=odbc
 /CONNECT="DSN=Excel Files;DBQ=C:\Users\gieselm\Documents\SPSSInc\demo.xls;"
 /TABLE="mySheet1"
 /KEEP= lfdn_neu2 KWJahr MonatJahr QuartalJahr
 /UNSELECTED=retain
 /REPLACE.

 

===================== 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

[PRogman]

What bit versions of are used? I remember reading about some issues when mixing 64bit software and 32-bit ODBC drivers, but I have never had the problem myself.

/PRogman

Bit-version and ODBC: http://www-01.ibm.com/support/docview.wss?uid=swg21591777
SPSS export to Excel: http://www-01.ibm.com/support/docview.wss?uid=swg21615805

[Jignesh Sutar]

MS office and SPSS Statistics bit-ness have to be a match (Not necessarily OS however).

[Mario Giesel]

Thanks to all - very helpful hints.

I could not solve this even with the help of our IT crew and I'm going to contact SPSS directly.

It might be a bit version issue, indeed.

Thanks again & gl,

  Mario

Jignesh Sutar <[hidden email]> schrieb am 15:13 Freitag, 26.Juni 2015:

MS office and SPSS Statistics bit-ness have to be a match (Not necessarily OS
however).



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SAVE-TRANSLATE-error-tp5729967p5729973.html

Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

[Mario Giesel]

Hi all,

  I just want to update this case.

We installed SPSS 23 as 32 Bit version and it worked after that.

Problem is indeed that MS programs are 32 Bit and don't understand 64 Bit "language".

As a side effect I can now even open MS Access databases without problems.

With 64 Bit version this was not possible.

Hope that helps someone out there.

  Mario

Mario Giesel <[hidden email]> schrieb am 15:21 Freitag, 26.Juni 2015:

Thanks to all - very helpful hints.

I could not solve this even with the help of our IT crew and I'm going to contact SPSS directly.

It might be a bit version issue, indeed.

Thanks again & gl,

  Mario

Jignesh Sutar <[hidden email]> schrieb am 15:13 Freitag, 26.Juni 2015:

MS office and SPSS Statistics bit-ness have to be a match (Not necessarily OS
however).



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SAVE-TRANSLATE-error-tp5729967p5729973.html

Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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