Exporting To Excel to Specific Cells?

[Guest]

I need to create time series data reports by exporting information from
Access to Excel (I don't have the option of generating the reports from
Access - per mgmt direction). The problem is that the dates and data are in
columns and I need them in rows for Excel. How do I export to excel so the
dates are in one row and become the column headings and the data associated
with the dates fall into the correct row/appropriate columns.

 

[Douglas J. Steele]

It's not really clear from your description exactly what it is you're trying
to do, but it's possible that creating a Crosstab query and exporting that
query rather than the table might help.