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

[John Bartley K7AAY]

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.

[frogsteaks]

On Jan 22, 11:16*am, John Bartley K7AAY <[e-mail]>
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
*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.

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.

[John Bartley K7AAY]

On Jan 22, 9:33 am, [e-mail] 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.