Access Export to Excell issues

[SJohnE]

Sometimes when a file is exported to Excel where there is a "D1" at the end of the data it is being replaced with 00 or 0. Data accessed by Access shows some stock codes as 37244D1 but when they export it comes out 372440. Numerical portion "37244" varies. Numerical value after the D varies.

Running Windows XP SP 3, MS Office 2003. ODBC connection to Oracle

Is anyone aware of this issue? and does anyone have a solution?

S J E
If I am not learning, then I am coasting, if I am coasting I must be going down hill.

 

[SkipVought]

Hi,

Are you sure that the alpha characer is D and not E?

Exactly how is the data exported to Excel?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]