Exporting to Excel

Are you selecting the right Excel format when you export? When I export data
from Access 2002, if I choose Excel 97-2002 format, I get more than 16,000
rows. If I choose any of the other Excel formats, including 5-7, I get only
16384.

On Mon, 7 Mar 2005 08:17:02 -0800, "Chris E."
<ChrisE@discussions.microsoft.com> wrote:

>My Access 2002's export interface (ISAM) seems to be associated with earlier
>versions of Excel and limits the numbers of rows that can be exported to
>16,000. How do I fix it so that I can export more rows?

I am exporting via VBA so maybe there's a registry setting that sets a
default when exporting this way? When I do a manual export it works ok but
when I run the code it errors out.

"Myrna Larson" wrote:

> Are you selecting the right Excel format when you export? When I export data
> from Access 2002, if I choose Excel 97-2002 format, I get more than 16,000
> rows. If I choose any of the other Excel formats, including 5-7, I get only
> 16384.
>
> On Mon, 7 Mar 2005 08:17:02 -0800, "Chris E."
> <ChrisE@discussions.microsoft.com> wrote:
>
> >My Access 2002's export interface (ISAM) seems to be associated with earlier
> >versions of Excel and limits the numbers of rows that can be exported to
> >16,000. How do I fix it so that I can export more rows?
>
>

What code are you using for the export? If it's the TransferSpreadSheet
method, it has an argument that allows you to specify the Excel version. If
that's not the way you are doing it, perhaps you should use this method.

From Access Help:
The TransferSpreadsheet method carries out the TransferSpreadsheet action in
Visual Basic.

expression.TransferSpreadsheet(TransferType, SpreadsheetType, TableName,
FileName, HasFieldNames, Range, UseOA)

expression Required. An expression that returns one of the objects in the
Applies To list.

TransferType Optional AcDataTransferType.

AcDataTransferType can be one of these AcDataTransferType constants.
acExport
acImport default
acLink
If you leave this argument blank, the default constant (acImport) is
assumed.


SpreadsheetType Optional AcSpreadSheetType.

AcSpreadSheetType can be one of these AcSpreadSheetType constants.
acSpreadsheetTypeExcel3
acSpreadsheetTypeExcel4
acSpreadsheetTypeExcel5
acSpreadsheetTypeExcel7
acSpreadsheetTypeExcel8 default
acSpreadsheetTypeExcel9 default
acSpreadsheetTypeLotusWJ2 - Japanese version only
acSpreadsheetTypeLotusWK1
acSpreadsheetTypeLotusWK3
acSpreadsheetTypeLotusWK4


"Chris E." <ChrisE@discussions.microsoft.com> wrote in message
news:EC48C9C1-AA46-425C-B271-6D85AC9D6C82@microsoft.com...
>I am exporting via VBA so maybe there's a registry setting that sets a
> default when exporting this way? When I do a manual export it works ok
> but
> when I run the code it errors out.
>
> "Myrna Larson" wrote:
>
>> Are you selecting the right Excel format when you export? When I export
>> data
>> from Access 2002, if I choose Excel 97-2002 format, I get more than
>> 16,000
>> rows. If I choose any of the other Excel formats, including 5-7, I get
>> only
>> 16384.
>>
>> On Mon, 7 Mar 2005 08:17:02 -0800, "Chris E."
>> <ChrisE@discussions.microsoft.com> wrote:
>>
>> >My Access 2002's export interface (ISAM) seems to be associated with
>> >earlier
>> >versions of Excel and limits the numbers of rows that can be exported to
>> >16,000. How do I fix it so that I can export more rows?
>>
>>