Truncated Memo Field - Exporting to Excel

G

Guest

Hi,

I'm exporting a query from Access 2003 to Excel 2003. All of the memo
fields are truncated to 255 characters. I know there is a way around this in
Access 2000, but the solution does not work for Access 2003. Please help.

Thanks.

Best regards,

Sheldon...
 
G

Guest

Hi Ken,

Sorry, I have been away for a few days.

I did not use TransferSpreadsheet at all. I tried Office Links on the Tools
menu, then I tried to Export to Excel manually.

Regards,

Sheldon...
 
K

Ken Snell [MVP]

The manual export process uses EXCEL 95 version of data... which means no
strings longer than 255 characters. You'll need to use a macro to run the
TransferSpreadsheet action (or use VBA code to run this action). There, you
can specify a current version of EXCEL (version 9, for example), etc. that
is not limited this way.
 
G

Guest

Thank you!

Ken Snell said:
The manual export process uses EXCEL 95 version of data... which means no
strings longer than 255 characters. You'll need to use a macro to run the
TransferSpreadsheet action (or use VBA code to run this action). There, you
can specify a current version of EXCEL (version 9, for example), etc. that
is not limited this way.
Click to expand...
 

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

Make Table Query Truncating Memo Field at 255 Characters 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Export to excel has character limit 3
Truncated memo field in query 3
disctinct query memo field 3
Memo Field data truncated in query 3
Exporting query to XL is truncating field data 7
Does a Select query copy memo fields correctly? 1

Top