Output to Excel

D

Dasa

Hi,
I'd like to export data to an excel file using macro, OutputTo action,
Output Format = Excel 97 - Excel 2003 Workbook (*.xls). No problem in Access
2007, but using Access runtime 2003 I get error message that output format is
not available.

Thanks for any help
Dasha
 
K

Ken Snell \(MVP\)

Use TransferSpreadsheet action. OutputTo will truncate long text strings.
 

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 from Access 2003 & Access 2007 to Excel 1
Macro to export query to Excel 2
Export Query using Access 2007 to Excel 2003 Users 2
Export from Access 2007 Report to excel 3
Export to spreadsheet error, help please 2
Access Table to Excel Spreadsheet 3
Access export to excel produces "unreadable data" 0
expoerting data to excel 1

Top