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)
 

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

Exporting Data to Multiple Tabs in Excel 1
Import Excel Workbook from Sharepoint 4
Exporting multiple queries into Excel workbook tabs 10
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
importing multiple worksheets from excel to access 1
How do you Export Data from Access into Multiple Tabs in Excel from one query 8
Export to excel in different tabs depending on criteria 5
Export data to Excel Column 1

Top