Problem with acFormatXLS

[tkosel]

I have a report in an Access 2003 front end that uses data from a SQL server
backend. It worked fine before, in a accesss 97 backend. When I converted,
the report now doesn't generate the proper output. Example text is included
below.

Below is the output from MSAcess report.

Clock# Normal_Shift Department Hours_Here Hours_Missed Reason_Code Comments Date Name Hourly
1758 3A A326 10 0 10/27/2005 HAGEMAN, TEDDY C -1
1811 3 A319 8 0

However, when I use the Access comand line:

DoCmd.OutputTo acOutputReport, "PayrollExcelSheet", acFormatXLS, V_Path

This is what I get in Excel:


Clock# Name Normal_Shift Department Hours Here Hours Missed Reason
Code Comments Date
1758 HAGEMAN, TEDDY C 0.125 A326 10 0 27-Oct-05


The normal shift numbers are not correct. Any ideas? When I look at in
using for example SQL server enterprise manager, the data is correct as well.
However the Access command :

DoCmd.OutputTo acOutputReport, "PayrollExcelSheet", acFormatXLS, V_Path

Yields a decimal number for the normal shift column which is a varchar field
in SQL.

I am expecting an output of 3A, but am getting a 0.125.

Any Ideas?