I have a table in Access that has roughly 800 rows. I am in need of turning rows to columns for an Export to Excel so I was creating a recordset to parse the data and Export to Excel. I have this part set, and can export all 800 rows in the proper format and very quick I might add.
We now have an added twist of the vendor system that we upload these .xlsx files to can only accept a .xlsx with a max of 45 columns. So my .xlsx with 800 columns is auto rejected due to the column limitation.
Would it be a more feasible solution to parse the master recordset into sub recordset every 45 rows (since we are turning rows to columns), or would it be easier to export the entire recordset to Excel, then allow access to control Excel and every 45 columns parse the data to a new workbook?
Actually - upon further thought - I *think* one would be able to split the recordset while still within access and generate multiple tables for every 45 records, then export those tables 1 by 1 to Excel....
Gurus?