<div>
The data only includes a monthly value if there is one. Some assets have a single cash flow record at maturity so I did NOT write 359 &quot;zero&quot; records when only 1 record was needed (with a date 30 years from today).<br />
<br />
My issue is that I can't use the crosstab query, therefore I will need to code this in VBA and write out the delimited text file.<br />
<br />
Thanks
</div>


The data only includes a monthly value if there is one. Some assets have a single cash flow record at maturity so I did NOT write 359 "zero" records when only 1 record was needed (with a date 30 years from today).

My issue is that I can't use the crosstab query, therefore I will need to code this in VBA and write out the delimited text file.

Thanks

<div>
Does anyone know if Access 2013 will allow more than 255 columns in a query (or table)?
</div>


Does anyone know if Access 2013 will allow more than 255 columns in a query (or table)?

<div>
<div class="content wysiwyg-content">
I have been asked to create an Excel spreadsheet from an Access database with about 365 columns of data. The Crosstab query that I used for this purpose was previously for 60 months of data plus some static information. This worked via the command:<br />
DoCmd.TransferSpreadsheet acExport, , &quot;qrySpec_FundFutCashFlow_C<wbr />rosstab&quot;, strExportFile<br />
<br />
I need a technique using VBA code to create an Excel spreadsheet with about 365 months of data (in columns) from an Access database.
</div>
</div>


I have been asked to create an Excel spreadsheet from an Access database with about 365 columns of data. The Crosstab query that I used for this purpose was previously for 60 months of data plus some static information. This worked via the command:
DoCmd.TransferSpreadsheet acExport, , "qrySpec_FundFutCashFlow_Crosstab", strExportFile

I need a technique using VBA code to create an Excel spreadsheet with about 365 months of data (in columns) from an Access database.

Access 2010 Maximum Crosstab Columns

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.