Better method for Exporting to Excel

's Computer Specifications

I've been using the DoCmd.OutputTo command to simply create a spreadsheet
from a query but it appears to only save as Excel 5 format from Access XP
2002 and I think the only option is "acFormatXLS". Is there another method
to create a simple spreadsheet from a Query without opening the spreadsheet?

's Computer Specifications

See TransferSpreadsheet in Help file.

--

Ken Snell
<MS ACCESS MVP>

"Geoff" <(E-Mail Removed)> wrote in message
news:Vwfse.5189$(E-Mail Removed)...
> I've been using the DoCmd.OutputTo command to simply create a spreadsheet
> from a query but it appears to only save as Excel 5 format from Access XP
> 2002 and I think the only option is "acFormatXLS". Is there another method
> to create a simple spreadsheet from a Query without opening the
> spreadsheet?
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Standard Method for Importing/Exporting to DB	Snozz	Microsoft VB .NET	2	6th Jun 2006 12:44 PM
exporting a C style method from DLL with dot-net	z. f.	Microsoft Dot NET Framework	2	2nd Dec 2004 12:49 PM
Re: Most efficient method of exporting a table or recordset to Excel	Michel Walsh	Microsoft Access Queries	0	21st May 2004 08:24 PM
Most efficient method of exporting a table or recordset to Excel	Mark	Microsoft Access Queries	0	21st May 2004 08:15 PM
exporting with SendObject method	Mike	Microsoft Access External Data	2	7th Nov 2003 02:27 PM