M
Michael Beckinsale
Hi All,
I have written a report in Access which is exactly as l want it. However to
feed the information into another external database l need to Analyse with
MS Excel.
When viewing the data in Excel the following conversion errors occur :
3959D001 appears as 39590
3959D002 appears as 395900
3959D003 appears as 3959000
3959D001HQ appears as 3959D001HQ
3959D001ST appears as 3959D001ST
The field is a text field in Access and the cells in Excel are formatted as
general. Whatever format is used in Excel results in the same error.
When the data item ends in a numeric it appears to me that Excel is
interpreting the "D" as an operator and adding the apprpriate number of 0's
Anybody got any idea's because i'm really stumped.
All suggestions gratefully received.
Regards
Michael Beckinsale
I have written a report in Access which is exactly as l want it. However to
feed the information into another external database l need to Analyse with
MS Excel.
When viewing the data in Excel the following conversion errors occur :
3959D001 appears as 39590
3959D002 appears as 395900
3959D003 appears as 3959000
3959D001HQ appears as 3959D001HQ
3959D001ST appears as 3959D001ST
The field is a text field in Access and the cells in Excel are formatted as
general. Whatever format is used in Excel results in the same error.
When the data item ends in a numeric it appears to me that Excel is
interpreting the "D" as an operator and adding the apprpriate number of 0's
Anybody got any idea's because i'm really stumped.
All suggestions gratefully received.
Regards
Michael Beckinsale