Access to Excel-Multiple tabs

  • Thread starter Thread starter JC
  • Start date Start date
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.
 
this might work:

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

(david)
 
Back
Top