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!
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!