Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2008-11-24 : 16:16:36
|
| Hi All, I'm facing a strange exporting issue to MS-Excel using MS-Access 2000.I've a report developed using MS-Access.For some strange reason when ever I export the report which does have account numbers 0000E49921,0000E10563,0000E94230 it is not displaying these numbers to excel 2003 instead it shows as 0(zero).When I export the report to .html or .rtf or .txt the account number is displayed correctly. Can anyone throw light why this is happening ? Appreciate all help.Thank you... |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2008-11-24 : 23:57:44
|
| It might be interpreting those values as exponential notation numeric values, try putting a single quote in front of each value and see if that makes Excel treat them as text, otherwise maybe put them in double quotes. |
 |
|
|
swenri
Yak Posting Veteran
72 Posts |
Posted - 2008-11-25 : 10:03:29
|
| I tried both the ways but, it doesn't work. Is there any other work around? Or is it bug in MS-Access 2000 exporting to MS-Excel 2003?Please help. Thank you. |
|
|
|
swenri
Yak Posting Veteran
72 Posts |
Posted - 2008-11-25 : 17:26:19
|
Issue resolved by fooling it. I concatenated it with an ' so that it will think as a text and export it. |
|
|
|
|
|
|
exporting to MS-Excel 2003 from MS-Access 2000