+ Reply to Thread
Results 1 to 2 of 2

Microsoft Query returns truncated data to Excel

  1. #1
    Registered User
    Join Date
    05-20-2007
    Posts
    1

    Microsoft Query returns truncated data to Excel

    Hello

    I have created a simple select SQL query that is presented perfectly in Microsoft Query (when importing data to Excel) but when I click "Return data to Excel" then Excel presents the data truncated to 8 characters and also confuses Greek encoding.

    (MS Office 2007, Database: Sybase Anywhere 6 - from "Micros" system)
    I have already checked the issues of IMEX and TypeGuessRows

    I would aprecciate very very very much any help

    Thanks in advance
    George

  2. #2
    Registered User
    Join Date
    03-31-2006
    MS-Off Ver
    Excel 2003
    Posts
    76
    What is truncated ?
    Is it the number of records or the fields length ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1