AccessHope
Registered User.
- Local time
- Yesterday, 23:08
- Joined
- Jul 12, 2006
- Messages
- 15
Hi, Everyone:
I have a table with 35554 records. I am exporting those records to Excel file.
It allow user to choose the location to save the file, the code like following:
DoCmd.OutputTo acTable, "Output Extract Data", "MicrosoftExcelBiff8(*.xls)", "", False, "", 0
It works before when it was fewer amounts of records. Now when I generate and export a report with 35554 records. The output file is missing, I can’t find on the location I saved.
Is anybody known why? Please help me!!
Many Thanks
I have a table with 35554 records. I am exporting those records to Excel file.
It allow user to choose the location to save the file, the code like following:
DoCmd.OutputTo acTable, "Output Extract Data", "MicrosoftExcelBiff8(*.xls)", "", False, "", 0
It works before when it was fewer amounts of records. Now when I generate and export a report with 35554 records. The output file is missing, I can’t find on the location I saved.
Is anybody known why? Please help me!!
Many Thanks
