Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exporting to Excel
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? |
#2
|
|||
|
|||
Among the less technical ideas, you might first confirm that all current
updates and Export filters have been installed. AFAIK, Access '02 should be able to export more than 16,000 records if the appropriate filters are available... unless you mean that an older Excel format must be used. You might also consider exporting as a text file & then importing that to Excel as a workaround. Keep checking back, as there may be other ways involving VBA that will bypass the limit. Good Luck |:) "Chris E." 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? |
#3
|
|||
|
|||
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." 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? |
#4
|
|||
|
|||
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." 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? |
#5
|
|||
|
|||
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." wrote in message ... 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." 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
exporting a chart to gif format using COM (Excel v11 and .net) | Charts and Charting in Excel | |||
Exporting numbers into Excel | Excel Discussion (Misc queries) |