Access 2000 output to Excel 2000

I

Ian

By default Access VBA outputs to Excel format in v5.0/95 format.

Is there any way to change this to Excel 2000 format in code, or a permanent
setting within Access?
 
P

Perry

With VBA you certainly can

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9

The AcSpreadsheetType enum offers the various Excel versions you can export
tables/queries to

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE
 

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

Autonumber field in Excel that behaves the same as Access 0
How to Write EXCEL files from a FORTRAN Program ? 0
Language of the templates 0
Table of content - format does not get saved 2
Excel does not accept text format! 0
Access 2002 change report header text 0
New computer, how do i move outlook 365 ENTIRELY? 0
Link Excel to word 2

Top