Excel Export

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I experience the problem in KB 823222 frequently - the article details an
issue when exporting to Excel from Access v2000, 2002 or 2003 that sometimes
values such as those in list A are export in the form in list B below. The
work-around provided in the article is painful with the volume and frequency
I encounter this. Is there a better way around this problem? Will it ever
get fixed??

List A (values in my DB):
212-20-100
515-22-985
553-2212-302

List B (get exported to excel as - SOMETIMES):
-61867
-857205
553-2212-302

or maybe as: (its entirely random!):
-457984329
515-22-985
-692845

Thanks for any clues!
 
Hi Steve,

I've never encountered this problem myself that I can remember. Two
questions:

1) Do these values exist in text fields in a table, or are you creating
them as calculated fields in a query that you are then exporting, or
what?

2) When you export these values to excel, does the formula bar show that
the values are *preceded* by an apostrophe? e.g. this in the worksheet
553-2212-302
appears as
'553-2212-302
in the formula bar. Does the apostrophe appear before all values, or
only the ones that have been exported correctly?
 
Thanks for the reply.

The values exits in a field in a table and the field is defined as a text
field

The values in the formula are not preceded by an apostrophe

I run into the issue described in that KB all the time - tried using Access
2000, 2002 and 2003 and same issue across the board and the KB article I
indicated seems to confirm that its a problem across all versions too.
 
Back
Top