What does string data, right-truncated mean

B

bmyer31

When I try to return data from Microsoft Query to Excell, I get an error. It
says [Cache ODBC][State: 01004][Native Code 1004][C:\Program Files\Microsoft
Office\Office12\EXCEL.EXE]String data, right-truncated. Through trial and
error I narrowed it down to one text field in my query that never has more
than 15 characters. What is causing the error and how do I return the data
to Excel?
 

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

Pass through query to oracle db 2
String data more than 200 characters in a cell 1
01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right 7
255 truncation 1
length of OLE Object fields; OCTET_LENGTH function not supported 0
Replace data to right of string problem 6
String too long, truncated, and just doesn't work. 4
Right Truncation warning 10

Top