Access to Excel-Multiple tabs

J

JC

Does anyone know if you can export an multiple Access
queries to one Excel file but in different worksheets? I
currently use the Transferspreadsheet command but I'd like
to put multiple slices of the same data on different tabs
in the same file... I'm currently using Access 2000.
 
D

david epsom dot com dot au

this might work:

33320 CodeDb.Execute "select * into [EXCEL 8.0;database=" & sFile & "].["
& sPage & "] from tblYC_PointData;"

(david)
 
Top