I am trying to run a CR XI report using an Excel 2003 spreadsheet for data selection in several SQL tables.  When I try to link the column CTN in the spreadsheet to an SQL table field called IN_NUM, I get the "Data types are not compatible" error message (field IN_NUM is numeric).  I have reformatted the column to be numeric, but it still won't work - CR sees the column as a string rather than numeric.  Yet other columns in the spreadsheet, formatted as "General" in Excel, are shown as numeric in CR??

Does anyone have any suggestions on how to fix this?  I had this working a while ago, but it seemed to be hit and miss - it would work sometimes, and not work other times.

Any suggestions are much appreciated.

Regards,

Rompinronny