issue with data transfer to excel

[kudurider]

Hi,

I have a database where the user can click on a button and it will export a table of data to a set location. The user is using a runtime Access 07 version.

The code I am using is:

DoCmd.TransferSpreadsheet acExport, 10, "T-History", "c:\database\agthistory.xlsx", -1
The issue is that only a portion of the data is transferred. Should I be using
the output code and creating a query instead trying to do the table? There is approx. 2500 records at this point which will continue to grow.

thanks

 

[Ranman256]

TransferSpreadsheet will export ALL data in the query.
so your query "T-History" must not have all the data.