Ado saves to Excel spreadsheet

  • Thread starter Thread starter Thomas
  • Start date Start date
T

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?
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top