automate export procedures

[leaf]

Hello there,

I would like to create a button on my startup page to
export all my tables into excel files, one table one excel
file. How do I accomplish that?

Thanks,

Leaf

 

[Sunny]

I am trying to export one of my query result into dbase table with following
syntax

docmd.TransferDatabase acExport, "dBase 5.0",
,acTable,"qryMyQuery","C:\temp\mytable.dbf"

but I am getting error "Invalid Argument" Can anyone guide me please?

Thanks.