FW: Desktop Reporter - Excel file formatting

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

FW: Desktop Reporter - Excel file formatting

Tierney, Mary Lou
 

Hello,

 

I am trying to merge data (Merge variables from one other data set)
from two Excel documents but I keep getting a failed merge message:
object cannot be cast from DBNull to other types.

 

I am a new Desktop reporter user - can anyone help me understand what
Excel formatting issues will cause a failed merge, i.e. blank cells,
etc.

 

One of the Excel files is also a 'Categories Export" (dichotomies) from
SPSS Text Analysis - is anyone aware of any issues with exported Excel
files from Text Analysis that get imported into Desktop reporter?

 

Looking for any insights - SPSS Tech Support has been abysmal.  

 

 

 

Mary Lou Tierney

Enterprise Architecture Planning and Innovation

The MITRE Corporation

p  781.271.8862

e  [hidden email]

 

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