i am getting the below error number and error message
2306,there are two many rows to output,based on the limitation specified
harinath88
Last Activity: Mar 6 '13, 06:45 PM
Joined: Sep 17 '12
Location: kolkata
-
harinath88 started a topic how to export bulk of datas from a sql pass through query to an excel file???in Accesshow to export bulk of datas from a sql pass through query to an excel file???
hi ,
i want to export datas from a sql pass through query to an excel file. i tried this query
but it is not working. here Q_3_Monthly_LC is a sql pass through query and txt contains file path.Code:DoCmd.OutputTo acOutputQuery, "Q_3_Monthly_LC", acFormatXLS, txt, False
-
i tried this, Tools|Options, Editor tab and check that Require Variable Declaration is turned on,but i idnt get the resultLeave a comment:
-
1.the query Q_3_Monthly_LC is working in back_end.it fetches exact records.the problem is while exporting the data into excel is not working
2.Actually the requirement is to generate the excel report
3.I didnt check the value for acSpreadsheetTy peExcel9. i will check and tell u
4.I used.Code:DoCmd.OutputTo acOutputQuery, "Q_3_Monthly_LC", acFormatXLS, txt, False
it is working for less than...Last edited by zmbd; Sep 22 '12, 07:20 PM. Reason: You must use the <CODE/> format button around any posted code. This has been asked several times!Leave a comment:
-
plese tell me the exact method to choose for fetching more than 20000 rows. i am using msexcel 2003.past five days i had been stuck into this code.could you please help me on this?Leave a comment:
-
Hi,
i got this error message
3251 operation is not supported for this type of object.Please, close b_all.xls file (Excel spreadsheet).Leave a comment:
-
actually below is the error message we put in code.i got this message only. My excel file name is b_all.xls
Code:MsgBox "Please, close b_all.xls file (Excel spreadsheet).", vbCritical, "File open"
Last edited by zmbd; Sep 17 '12, 05:20 PM. Reason: please use the code button to place tags around posted code.Leave a comment:
-
harinath88 started a topic How to export 20000 records from a sql_pass through query to an excel file ?in AccessHow to export 20000 records from a sql_pass through query to an excel file ?
this query is worked only for below 17000 recors but this fails while fetching more than 18000 records.Code:DoCmd.OutputTo acOutputQuery, "Q_3_Monthly_LC", acFormatXLS, txt, False,
i tried to use this code but it is also not working
Code:DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "Q_3_Monthly_LC", txt, False
No activity results to display
Leave a comment: