I
Ilya
Hi all!
I have some weird problem with transferring data from Access 2002 to
Excel.
I use a simple command which is DoCmd.TransferSpreadsheet acExport, 0,
QueryName, Path, True to export the result of the query to Excel.
The problem is that for some reason not all the data is exported to
Excel without any proper reason. The query I'm using is a dynamic
query which is built through code. Sometimes the export exports all
the data that is seen by just opening the results of the query. But
for some reason when the same query has rowcount of 33873 Excel file
generated by this resultset has only 16383 rows after the export.
What could be the reason for such filtering?
Thanks in advance for any help!
Ilya
I have some weird problem with transferring data from Access 2002 to
Excel.
I use a simple command which is DoCmd.TransferSpreadsheet acExport, 0,
QueryName, Path, True to export the result of the query to Excel.
The problem is that for some reason not all the data is exported to
Excel without any proper reason. The query I'm using is a dynamic
query which is built through code. Sometimes the export exports all
the data that is seen by just opening the results of the query. But
for some reason when the same query has rowcount of 33873 Excel file
generated by this resultset has only 16383 rows after the export.
What could be the reason for such filtering?
Thanks in advance for any help!
Ilya