Export Data to Excel

N

Naresh Nichani MVP

Hi:

If the data in List is from a table on based on a SQL statment use thhsi VBA
code on a button to do the excel export.

application.DoCmd.TransferSpreadsheet
acExport,acSpreadsheetTypeExcel3,"TableName","C:\My DOcuments\Test.xls"

Here TableName is the name of Table to export and is exported to Test.xls.

Regards,

Naresh Nichani
Microsoft Access MVP
 

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

Solved Disk Full error message when exporting PDF 0
Images are pixelated when saving to PDF 0
Using Office Forms and dynamically updating the excel backend 0
Sorting and filtering text 0
VBA - exporting serial letters to single documents 0
How to export html text as word document with specific size and orientation 0
Converting isse with Export in Outlook 0
Embed the same Excel multiple times 0

Top