Ado saves to Excel spreadsheet

[Thomas]

How can I save the results of a querry (through ADO) to an
excel spread sheet through Access 2000 VBA. Since the
voulume of data is too large, saving each field in each
cell is taking a lot of time. Is there any quicker way to
save it to an excel spread sheet?

 

[[MVP] S. Clark]

The Save method in ADO will allow you to save the data to an XML file, which
Excel can open.

rst.Save "FileName", adPersistXML

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-