ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS query returns truncated data to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/143415-ms-query-returns-truncated-data-excel.html)

memeli

MS 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 check the issues of IMEX and TypeGuessRows

I would aprecciate very very very much any help

Thanks in advance
George


All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com