1

255 Max character size in Excel cell when cell data is linked/fetch from external data source

view story
linux-howto

http://superuser.com – I have one bug tracking system which export bug data as Excel file. I would like to create a report based on this exported excel file. what I did is create a office data connection file which link to the export excel file. DBQ=\myfileserver\01_Team_Weekly\Raw\Raw.xlsx;DefaultDir=\myfileserver\01_Team_Weekly\Raw\;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;ReadOnly=1;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes; SELECT * FROM \\myfileserv (HowTos)