L
Leslie
This only recently has become a problem (cause due to a Microsoft update???)
When we export a report from Access, Excel (or Access?) automatically
formats the spreadsheet, using sub-totals for cols 1-3 (thus the data
disappears) and Excel's column1 contains the data from column 4 of the report:
Access Report Format:
Col1 Col2 Col3 Col4
a a a a
a
a
b b b b
b
b
Excel Result:
123 Col1
- a
| a
- a
- b
| b
- b
We actually simply want all of the data from the first three columns to load
into Excel, regardless of the formating. Is there any magic to this (some
setting in Access or Excel?) (We are actually using the right click on the
report and choosing SEnd, then choosing the export format.)
Thanks,
Leslie
When we export a report from Access, Excel (or Access?) automatically
formats the spreadsheet, using sub-totals for cols 1-3 (thus the data
disappears) and Excel's column1 contains the data from column 4 of the report:
Access Report Format:
Col1 Col2 Col3 Col4
a a a a
a
a
b b b b
b
b
Excel Result:
123 Col1
- a
| a
- a
- b
| b
- b
We actually simply want all of the data from the first three columns to load
into Excel, regardless of the formating. Is there any magic to this (some
setting in Access or Excel?) (We are actually using the right click on the
report and choosing SEnd, then choosing the export format.)
Thanks,
Leslie