Exporting To Excel to Specific Cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top