Create Excel spreadsheet with 500 columns from Access crosstab query
Posted on 2011-02-17
In Access 2010, I want to run a crosstab query and export the result to Excel. However, the crosstab doesn't work because it creates more than 255 columns. I suppose I could split the query into two (or more) queries that result in fewer than 256 columns, and then combine the two Excel spreadsheets into a single spreadsheet. However, that could become cumbersome if there are thousands of columns. It might also be tricky ensuring that the key value in the two Excel sheets is identical for each row.