Hello Fellow SPSS Coders!
Here is an issue I am having trouble rectifying: I am trying to export an SPSS database to a specific worksheet within an Excel 2010 (.xlsx) file. The code below exports the SPSS database to the appropriate worksheet (called "Results") only if change the Excel file extension to .xls (Excel 1997-2003). If I keep the .xlsx extension, I receive the following error ("The ODBC subsystem has issued an error which prevents the processing of SAVE TRANSLATE ODBC request). I won't go into the specific details why I need the data exported into a later version of Excel, but it is very important that I do. I am running the 64-bit version of SPSS 20. All documentation I've read to date states that SPSS 20 can export data to a specific .xlsx worksheet. Any idea what may be going on here?