Yes, my password is: Forgot your password? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original Monday, April 16, 2012 7:53 PM Reply | Quote 0 Sign in to vote Yes, I did leave some of things out because there are too many repeatitions; there are a Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. weblink
First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Rana Irfan Ahmad @ U.A.E., Sharja Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... I've tested the code and now it works fine - problem solved!Murray« Next Oldest· Access Modules· Next Newest »Display Mode: Standard · Switch to: · Switch to: OutlineTrack this topic ·Email The DoCmd.SendObject statement itself works fine for me, when executed from the Immediate window. http://www.pcreview.co.uk/threads/solution-error-2306-there-are-too-many-rows-to-output-access-to-excel-using-outputto.3146025/
Ask Questions for Free! DoCmd.OutputTo acOutputQuery, "My Query", > acSpreadsheetTypeExcel9, "C:\Document\MyFile.xls", True > > BTW I'm using Microsoft Access 2003 SP2 > > --John Hunter Allen Browne, Jul 3, 2007 #2 Advertisements Show Ignored This is driving me crazy, so any ... Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
Hopefully this will help someone who is searching on this issue. -- Allen Browne - Microsoft MVP. Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html Marked as answer by ttim Tuesday, April 17, 2012 12:57 PM Monday, April 16, 2012 10:03 PM Reply | Quote 0 Sign in Out of curiosity, why do you use Excel 97 - Excel 2003 Workbook (*.xls)" while I have Access 2007? I know the reason is because of the default to an old version of Excel which only allows 16K rows while mine has more than that.
CONTINUE READING Join & Write a Comment Already a member? We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. http://database.ittoolbox.com/groups/technical-functional/access-l/solution-error-2306-there-are-too-many-rows-to-output-4078036 Covered by US Patent.
Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... I Am using Office 2000. All product names are trademarks of their respective companies. RE: Too Many Rows To Output Error (2306) vbajock (Programmer) 19 Nov 03 17:03 The row limit for Excel is 65,536 records.
Red Flag This Post Please let us know here why this post is inappropriate. You should be able to convert it to VBA. ' Begin Code Dim Excel As Excel.Application ' This is the excel program Dim ExcelWBk As Excel.Workbook ' This is the work Can a query be used if I am working with an ADP type file ? And one solution is use DoCmd.OutputTo acOutputQuery, "My Query", acSpreadsheetTypeExcel9, "C:\Document\MyFile.xls", True But I want to send the excel file directly to the user, not to my local machine.
Could the following records which exist in table tblDtlBranchAll be manipulated in a stored procedure to create the sorted records with totals and subtotals that follows below the dotted lines into http://divxpl.net/microsoft-access/microsoft-access-error-3033.html When I try to run it, I get:Run-time error '2306':There are too many rows to output, based on the limitation specified by the output format or by Microsoft Access. Close the form ( so linked Excel file is not actively locked ) 2. Maybe we can see what's wrong from that.
Out of curiosity, why do you use Excel 97 - Excel 2003 Workbook (*.xls)" while I have Access 2007? What I asked for and was hoping to see was the entire code of the module, copied and pasted, so that I can see whether there is something else wrong in I am still using Office2007 and I have got solution to my problem. check over here Mate Group CEO www.it-mate.co.uk PB
That will let you specify a newer version of EXCEL and therefore you can export more data. -- Ken Snell
When I run the Macro I have the same message "Do you want to replace the existing file"?
Register now while it's still free! Import text file into that temp table. 4. I don't know what I was doing wrong before. Irfan Rana replied Mar 6, 2011 Dear Siddiq, Well that's not my problem.
Using Access 2002 on XP Pro. Close Box Join Tek-Tips Today! Join UsClose Help Register Log in Remember Me? this content DoCmd.OutputTo acOutputQuery, "qryDownaloadAll", _ acFormatXLS, XFile, False Now after changing , DoCmd.OutputTo acOutputQuery, "qryDownaloadAll", acSpreadsheetTypeExcel12, XFile, False It works fine for me.
Access 2007 Button remains disabled inside a frame after cliked once. Even when I reduce the table to 14,000 records, the error is generated because the rptDtlBranchAll creates additional records for subtotals and totals. 0 Comment Question by:zimmer9 Facebook Twitter LinkedIn Email I should ask also, how many rows does your query return?