Exporting to Excel

[Reeni]

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

 

[David Lloyd]

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?

--
David 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