none
Import SQL query to Excel 2007 RRS feed

  • Question

  • I have an Excel 2003 spreadsheet with data tables linked to SQL Server queries.   I ended up in an environment with only Excel 2007 available, so I was running in compatability mode.  When I tried to use Query to get at SQL Query via ODBC everything worked fine until I actually had data returned ...  5 of 36 columns were missing even though they definitely showed up in the preview.   Using SQL Server Express installed by MSCRM.
    Friday, April 25, 2008 2:47 AM

Answers

  • It turns out that query was returning 'raw' data from a user defined field of type DataTime.  Casting as DateTime resolved the issue.
    Wednesday, May 28, 2008 2:08 PM