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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel Workbook from Sharepoint 4
Exporting Data to Multiple Tabs in Excel 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do you Export Data from Access into Multiple Tabs in Excel from one query 8
importing multiple worksheets from excel to access 1
Transfer Spreadsheet into Excel 5
Exported Excel File is Incomplete 14
Exporting Data to One Excel Workbook to Several Worksheets 2

Back
Top