is there some reason i can't use a view as an export source with DoCmd.TransferSpreadsheet acExport? i gat an error message that says my view cannot be found. triple checked the spelling etc. tia, mcnewsxp