(Msg. 1) Posted: Thu Feb 14, 2008 5:41 am
Post subject: What causes the string data, right-truncated error? Archived from groups: microsoft>public>excel>querydao (more info?)
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?
(Msg. 2) Posted: Fri Feb 15, 2008 12:05 am
Post subject: Re: What causes the string data, right-truncated error? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Don't know what's causing the problem and haven't seen it myself.
What is the source of the data, and how is the field in question
defined on the datasource?
Bill Manville
MVP - Microsoft Excel, Oxford, England
(Msg. 3) Posted: Fri Feb 15, 2008 8:07 am
Post subject: Re: What causes the string data, right-truncated error? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks for your prompt response. We use a Cache post relational database.
Microsoft Query connects to it via an ODBC. The field is calculated and is
defined as a text field of length 15 and nullable. It display fine in
Microsoft Query. The error occurs when you try to return the results to
Excel. When the field is dropped from the query, the returns to Excel
without error.
"Bill Manville" wrote:
> Don't know what's causing the problem and haven't seen it myself.
> What is the source of the data, and how is the field in question
> defined on the datasource?
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
>
>
(Msg. 4) Posted: Fri Feb 15, 2008 8:22 am
Post subject: Re: What causes the string data, right-truncated error? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
My first reply was partly in error. The field is calculated but is a
numerical field of length 17 and is nullable.
"Bill Manville" wrote:
> Don't know what's causing the problem and haven't seen it myself.
> What is the source of the data, and how is the field in question
> defined on the datasource?
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
>
>
(Msg. 5) Posted: Sun Feb 17, 2008 8:47 am
Post subject: Re: What causes the string data, right-truncated error? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Can you give some extreme examples of the values that appear in this
calculated field?
17 digits of precision is actually more than Excel can handle so maybe
that is an indication of the cause of the problem
Bill Manville
MVP - Microsoft Excel, Oxford, England
(Msg. 6) Posted: Tue Feb 19, 2008 5:29 am
Post subject: Re: What causes the string data, right-truncated error? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Bill Manville" wrote:
> Can you give some extreme examples of the values that appear in this
> calculated field?
> 17 digits of precision is actually more than Excel can handle so maybe
> that is an indication of the cause of the problem
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
>
>
(Msg. 7) Posted: Tue Feb 19, 2008 5:40 am
Post subject: Re: What causes the string data, right-truncated error? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The field is for loan payments so the values are never more than a few
thousand dollars and some cents, however, I did find something interesting. A
few of the values include a non-numeric value (254.55P is one example). Could
this be the problem? In the meantime, we are reviewing the calculation
procedure to see how a non-numeric result could be possible.
"Bill Manville" wrote:
> Can you give some extreme examples of the values that appear in this
> calculated field?
> 17 digits of precision is actually more than Excel can handle so maybe
> that is an indication of the cause of the problem
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
>
>
(Msg. 8) Posted: Tue Feb 19, 2008 1:52 pm
Post subject: Re: What causes the string data, right-truncated error? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Bmyer31 wrote:
> A
> few of the values include a non-numeric value (254.55P is one example). Could
> this be the problem?
>
Sounds highly likely - the truncation on the right would be the removal of the
"P". Pleased you have probably resolved it.
Bill Manville
MVP - Microsoft Excel, Oxford, England
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office