Page Comparison

{info}
This page is devoted to *frequently asked questions* (FAQ) related to export.
{info}

\\

{on-this-page}

h2. Is there a limit on the number of rows that can be exported to Excel?

*Extended Question:* Some of the results tables I have for a bridge model are cut-off around 65,000 rows when exported to Excel. Is there an explanation for this limitation?

*Answer:* Excel versions before 2007 are limited to 256 columns and 65,536 rows. With the release of Excel 2007, these limits expandedextended to 16,385 columns and 1,048,576 rows. If Excel 2007 (or a later version) is installed, {new-tab-link:http://www.csiberkeley.com/}CSI{new-tab-link} Software will automatically use the enhanced data handling when creating Excel files.

Additional suggestions include export to Access database, which does not limit the number of rows, or incrementally export smaller portions of the model.


h2. Why can't I export a table to Excel when doing interactive database editing?

To resolve this issue, commonly reported as error # 430, please complete the following process:

# Unregister DAO by selecting Start > Run, copy and paste the line below, then select OK
\\
\\
{code}
regsvr32 /U "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll"
{code}
\\
# Re-register DAO by selecting Start > Run, copy and paste the line below, then select OK
\\
\\
{code}
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll"
{code}


{hidden-content}
*Relevant email:*

* {email:to=ok|from=rs|date=11/8/2010|subject=Unable to export to Excel|comment=Re-registering the relevant DLL may resolve the problem|id=6357124}
{hidden-content}