export ACCESS table into EXCEL file 1

[schnigger]

Hi there,

I am trying to export an MS ACCESS table into an EXCEL *.xls file using VBA code.

I've no problem with creating a *.dbf file, using the code:

DoCmd.TransferDatabase acExport, "dbase IV", _
"E:\Database\db_main", acTable, "export_prj_exc", _
"pastis.dbf"

But I can't find the right string I have to enter in order to get an Excel file instead - though this option (MS EXCEL 3, MS EXCEL 4 etc.) is an export option when using the standard ACCESS pulldown menu.

Anyone out there who knows?

 

[mp9]

You need

DoCmd.TransferSpreadsheet...

or, better still,

DoCmd.OutputTo...

Both are expansively detailed in Access help.

http://www22.brinkster.com/accessory/

 

[schnigger]

that was easy!
Thanks

Schnigger