none
Suggestion: Improve datatypes of exported data with Excel 2003

    Question

  • 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

Answers

  • 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 http://connect.microsoft.com/sql 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 - http://support.microsoft.com/select/default.aspx?target=assistance

    Wednesday, January 29, 2014 4:56 AM
    Moderator