 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / December 2005Exporting to Excel
Hi Hope somebody can help.. I have used transferspreadsheet to export 38 queries to one excel worksheet... by adding a4:1000 and gone up by a thousand resulting in blank rows... The problem is that there are alot of blank rows... because each time the queries are run with new data the number of data rows changes ... Is there any way of not have blank rows... i hope this makes sense thanks in advance Reeni  SignatureReeni Reeni: I don't know all the specifics of your export, however, its sounds as though you are just incrementing by a thousand rows with each query export(?). Have you tried opening each query as a recordset prior to export and reading the RecordCount property to dynamically adjust the increment? SignatureDavid Lloyd MCSD .NET http://LemingtonConsulting.com This response is supplied "as is" without any representations or warranties. Hi Hope somebody can help.. I have used transferspreadsheet to export 38 queries to one excel worksheet... by adding a4:1000 and gone up by a thousand resulting in blank rows... The problem is that there are alot of blank rows... because each time the queries are run with new data the number of data rows changes ... Is there any way of not have blank rows... i hope this makes sense thanks in advance Reeni SignatureReeni |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.