output from access to excel using office links 2

[smurf01]

Hi, I wonder if someone can help me, I have a table in Access with 17863 rows, I am trying to export the data to excel using Tools > office links > analyse it with excel. the problem is that I get the following error message and I don't know where to look to solve the problem.

"There are too many rows to output based on the limitations specified by the output or Microsoft Access" Regards

Paul

 

[AirZebra]

Hi Paul,

We always get this message if the number of rows is over 15,000 (using Office 97). We use three workarounds depending on the situation.

1. Export the data as XLS file, open file in Excel.
2. From Excel use the get external data option, or create a pivot table using the external source data option.
3. Split the data in Access into two sets (each under 15,000 records), take each one separately into Excel and then join them together.

If any one else knows a better way of fixing this then I too would appreciate it.

Regards,

Alan

 

[combo]

If you have office 2k/xp, you can export up to 65535+header.
This requires macro, for instance:

[tt]Sub ExportXL2000()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "MyTable", "Full_path\OutputFile.xls", True
End Sub[/tt]

 

[Zmey2]

See this article:

http://www.zmey.1977.ru/Access_To_Excel.htm

 

[smurf01]

AirZebra/Combo

AirZebra, I am using Office 2000 therefore Combo's solution is the one I want, however thanks for the info it may come in useful in the future as we do have some users with Office 97. Have a star

Combo, Thank You it worked a treat, have a star Regards

Paul