[AccessD] Access Toolbar Question

Max,

I have sometimes found that OutputTo method can be preferable to 
TransferSpreadsheet in cases like this, as data typing and formatting 
seem to be better retained.

Regards
Steve


Gmail wrote:
> Hi Arthur,
> This will output a Table or Query into Excel
> 
> DoCmd.TransferSpreadsheet acExport, , "qBELnk_MenuGroupsSub",
> "C:\qBELnk_MenuGroupsSub", True ' change output path to suit.
>