DoCmd.OutputTo acOutputQuery, "Knight Compare", acFormatXLSX, "c:\apps\xp\Desktop\Project File\EXCEL FILES\Output Folder\Knight \Knight.xlsx", False
Looks like ur basic output code; However, The issue im having is the actual output size is over 205000 rows but when I run this module, Only 65000 rows are saved to the XLS file.
Is there a way to have the module save all the rows??
PLEASE HELP...
What version of Excel are you using. Your profile indicates 2003, but you did indicate that you are using Access 2007. Just need to verify before giving an answer that will be workable for you.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
Sorry....just upgraded to 2007 yesterday....so all 2007Originally Posted by alansidman
I would use the Transfer Spreadsheet method. Look at this for the syntax. As a matter of course, I believe that the acSpreadsheetType should be Excel12 for v.2007
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks