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

 

[Kevin3NF]

Create a macro with a seperate TransferSpreadsheet Action for each table.
Call that macro in the OnClick Event of your button.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[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.