Suggestion: Improve datatypes of exported data with Excel 2003


  • If I export data that has been cleansed and then use that as the source for a matching operation, the datatypes no longer match my domain. E.g. a date is just an nvarchar from Excel.
    Tuesday, January 07, 2014 9:08 PM


  • If I recall how it works, the Excel provider (ACE) can automatically determines data types by sampling the first few rows in the data. I agree it would be a nice to have data type parity with the source.

    For suggestions, you will get better traction if you file them at where folks can vote on them.

    Thanks, Jason

    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation -

    Wednesday, January 29, 2014 4:56 AM