I'm facing a strange exporting issue to MS-Excel 2003 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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting problem to MS-Excel 2003 with Ms-Access 2000
- Thread starter swenri
- Start date
SkipVought
Programmer
Hi,
Excel is trying to be helpful. Give Bill a break!
0000E49921 looks like scientific notation to Excel. So Excel CONVERTS it to a number.
Other instances of "help" are...
[tt]
9: is converted to TIME
1/7 is converted to DATE
[/tt]
So what can a guy or gal do? PREFIX values in this column with an APOSTROPHY, which will make the values be considered to be "labels" or TEXT by helpful Excel.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my old subtlety...
for a NUANCE!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
Excel is trying to be helpful. Give Bill a break!
0000E49921 looks like scientific notation to Excel. So Excel CONVERTS it to a number.
Other instances of "help" are...
[tt]
9: is converted to TIME
1/7 is converted to DATE
[/tt]
So what can a guy or gal do? PREFIX values in this column with an APOSTROPHY, which will make the values be considered to be "labels" or TEXT by helpful Excel.
Skip,
[sub]
Just traded in my old subtlety...for a NUANCE!
[/sub]- Status
Similar threads
- Locked
- Question
- Locked
- Question
