Access 2003: Output to Excel corrupts one, just one, cell"s value

When I output a table's values to XLS, one value in a very small
table, and only one value, is changed.

Here are the values in the table, tblLevel.

LEVEL
H-14
0
1
1.1
1.2
1.3
1b
2
2.1
2.2
3
3.1
3.2
3b
4
4.1
4.2
4a
5
5.1
High
Low
Main
Medium

Yet, when output to Excel as an XLS, here's what Access created:

LEVEL
H-14
0
1
1.1
1.2
1.3
1b
2
2.1
2.2
3
3.1
3.2
3b
4
4.1
4.2
0.166666667
5
5.1
High
Low
Main
Medium

If I change the value from 4a to 4b, 4b is output to Excel, but when I
change the value back to 4a, once again Excel gets the value
0.166666667.

Field Properties are as follows:
LEVEL is a text field.
Field size is 10
Data entry required is Yes
Allow Zero Length is No
Indexed is Yes (No Duplicates)
Unicode Compression is No
IME Mode is No Control
IME Sentence Mode is None
The Display Control is a Text Box.

I do this export with many other tables, and don't get this error.

You will notice the value 3b in another cell exported just dandy.

Your on-topic suggestions will be graciously appreciated.

Re: Access 2003: Output to Excel corrupts one, just one, cell"s value

On Jan 22, 11:16=A0am, John Bartley K7AAY
wrote:
> When I output a table's values to XLS, one value in a very small
> table, and only one value, is changed.
>
> Here are the values in the table, tblLevel.
>
> LEVEL
> =A0H-14
> 0
> 1
> 1.1
> 1.2
> 1.3
> 1b
> 2
> 2.1
> 2.2
> 3
> 3.1
> 3.2
> 3b
> 4
> 4.1
> 4.2
> 4a
> 5
> 5.1
> High
> Low
> Main
> Medium
>
> Yet, when output to Excel as an XLS, here's what Access created:
>
> LEVEL
> =A0H-14
> 0
> 1
> 1.1
> 1.2
> 1.3
> 1b
> 2
> 2.1
> 2.2
> 3
> 3.1
> 3.2
> 3b
> 4
> 4.1
> 4.2
> 0.166666667
> 5
> 5.1
> High
> Low
> Main
> Medium
>
> If I change the value from 4a to 4b, 4b is output to Excel, but when I
> change the value back to 4a, once again Excel gets the value
> 0.166666667.
>
> Field Properties are as follows:
> LEVEL is a text field.
> Field size is 10
> Data entry required is Yes
> Allow Zero Length is No
> Indexed is Yes (No Duplicates)
> Unicode Compression is No
> IME Mode is No Control
> IME Sentence Mode is None
> The Display Control is a Text Box.
>
> I do this export with many other tables, and don't get this error.
>
> You will notice the value 3b in another cell exported just dandy.
>
> Your on-topic suggestions will be graciously appreciated.

I recreated your table and ran an export to excel. I got 4a in the
record in question. Delete the record, re-add it. perhaps compact/
repair. try again.

Re: Access 2003: Output to Excel corrupts one, just one, cell"s value

On Jan 22, 9:33 am, frogste...@yahoo.com wrote:

> I recreated your table and ran an export to excel. I got 4a in the
> record in question. Delete the record, re-add it. perhaps compact/
> repair. try again.

Tried both, neither helped. Thanks for the suggestion, though.

Re: Access 2003: Output to Excel corrupts one, just one, cell"s value

On Tue, 22 Jan 2008 08:16:20 -0800 (PST), John Bartley K7AAY
wrote:

>When I output a table's values to XLS, one value in a very small
>table, and only one value, is changed.
>

Big snip


>If I change the value from 4a to 4b, 4b is output to Excel, but when I
>change the value back to 4a, once again Excel gets the value
>0.166666667.
>
>Field Properties are as follows:
>LEVEL is a text field.
>Field size is 10
>Data entry required is Yes
>Allow Zero Length is No
>Indexed is Yes (No Duplicates)
>Unicode Compression is No
>IME Mode is No Control
>IME Sentence Mode is None
>The Display Control is a Text Box.
>
>I do this export with many other tables, and don't get this error.
>
>You will notice the value 3b in another cell exported just dandy.
>
>Your on-topic suggestions will be graciously appreciated.

Wild guess. Check *all* your code to see if '4a' is being assigned and/or
calculated to a value. 0.166666667 = 1/6. Could 'a' be assigned a value of
1/24 and 4a looks like 4*a? Change 3b to 3a and see what happens. 3 * (1/24)
= 1/8 = 0.125

Chuck
--