[OzTFS] Data truncated to 255 characters when copying TFS-Excel form

[Robert Manger]

Hi there,   Here is the problem.  I am trying to migrate data from my old problem tracker database into TFS using the following steps:   -          Create Excel Spreadsheet 1 with ODBC connection to old problem tracker database to grab all required data -          Create Excel Spreadsheet 2 with a connection to TFS with all required fields -          Copy all required data from spreadsheet 1 to spreadsheet 2 -          Publish data in Spreadsheet 2 into TFS   This process works beautifully, apart from one reasonably major problem.  Data within fields are being truncated to 255 characters.    The data in question is fine in the ODBC connection, so it is not the issue laid out in MSDN support article http://support.microsoft.com/kb/189897/. I can also manually enter data in a TFS-Excel field greater than 255 characters. The issue is only in the copying process.   What is going one here?  Does anyone have any fixes? Does anyone have any suggested workarounds?   Cheers   Rob Manger Test Analyst SEEK Limited Level 2, 3 Wellington St St Kilda, Victoria, 3182 PH : +61 3 8517 4181 URL : www.seek.com.au     OzTFS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net