Exporting table to spreadsheet in VBA

[DoniFromMars]

Looking for a way to export an access table to a spreadsheet
using VBA. I can export it from the Menu le,export,..datbase type..)
but the vba doesn't recognize the database type "microsoft excel"
How do you tell vba that you want a spreadsheet
thanks for any help

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DoniFromMars]

DoCmd.TransferDatabase acExport, "?????", _
"P:\anytownUSA\max.mdb", _
acTable, "Tablename", "P:\anytownUSA\fred.xls"

Thanks . It doesn't accept any value I put in place of the
?????. thats where I'm supposed to specify MSexcel.

the message i get is :
022507: The ????? type isn't an installed database type or doesn't support the operation you chose.

 

[Remou]

I think PHV mentioned TransferSpreadSheet.