Crosstab Query Exported from Access to Excel

  • Thread starter Thread starter Aaron Reid
  • Start date Start date
A

Aaron Reid

I am trying to export a crosstab query into an Excel spreadsheet. Using DAO in Access 2000, I can use the following code to work for
the first row but how do I reference the second and third rows from the crosstab? After the export is successful, the data is used
for a chart.

ExcelWRK.Cells(2, 1).Value = "Title One"
ExcelWRK.Cells(3, 1).Value = "Title Two"
ExcelWRK.Cells(4, 1).Value = "Title Three"
ExcelWRK.Cells(2, 2).Value = rs.Fields(J + 5).Value

Thanks for any help!

AJR
 
Aaron Reid said:
I am trying to export a crosstab query into an Excel spreadsheet. Using DAO in
Click to expand...
Access 2000, I can use the following code to work for
the first row but how do I reference the second and third rows from the
Click to expand...
crosstab? After the export is successful, the data is used
for a chart.

ExcelWRK.Cells(2, 1).Value = "Title One"
ExcelWRK.Cells(3, 1).Value = "Title Two"
ExcelWRK.Cells(4, 1).Value = "Title Three"
ExcelWRK.Cells(2, 2).Value = rs.Fields(J + 5).Value

Thanks for any help!

AJR
Click to expand...

There is nothing special about your recordset just because the records came from
a crosstab query. When you are done with the first record, you do rs.MoveNext to
go the next row.
 
Back
Top