Duane Hookom's Concatenate Theory

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!
 
K

Ken Snell

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duane Hookom's - Concatenate and filter by Column 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Concatenate-Access 2003 4
Concatenate function from a Query, not a table 5
using Duane Hookom's Concatenate Module 2
concatenate function max characters? 4
EXPORT QUery with memo field to excel, truncated data 2
Concatenate error - Duane Hookom's concat function 6

Top