Exporting to Excel 2007

  • Thread starter Thread starter TMC
  • Start date Start date
T

TMC

I ran a query in Access 2007 with the following results (1st row is header
row):
Cmp S1 S2 S3
ABC 0 48 86
CDE 0 0 0
EFG 94 10 53

No problem so far, that's what I expected to see. The problem is when I
export this to Excel 2007, without checking the "export data with formatting
and layout" box, Excel only shows
Cmp S1 S2 S3
ABC 0 48 86
EFG 94 10 53

Company CDE completely disappears! However, when I go back to export it to
Excel again, this time checking the "export data with formatting and layout"
box, low and behold the Excel data now matches the query output.

Ok, so why in the world does company CDE, just because it has zeros in all
it's value fields, get "nuked" when exporting it without formatting options?
I just want the raw data dumped to Excel without formatting, yet there is no
guarantee that all records will be returned without checking the "export data
with formatting and layout" box? Company CDE values aren't null, and this is
clearly not a leading zero issue, so completely stumped here, not even sure
if it's a problem with the way Access exports or the way Excel treats the
incoming data.

Any insights would be appreciated!
 
It works fine to me. No problem. Check Excel, if you checked Show zero in
Excel option window.
Andy Krajnc
 
Back
Top