Duane Hookom's Concatenate Theory

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

I am using Duane Hookom's concatenate theory. I have
exactly what in need in my query (my concatenated field is
larger than 255 characters and it appears fine in the
query with all the data that should be there). The problem
is when I export this query to Excel, it limits my field
to 255 characters. Help!
 
Use TransferSpreadsheet to transfer the query...if you use File | Export
option, it uses an older format of EXCEL and that format truncates long
strings.
 
Back
Top